Re: java error

On Apr 18, 2022, at 11:19 AM, Colin Williams <colinwilliams007@xxxxxxxxx> wrote:

Good that you got it figured out.

Not sure what you mean by your WRKENVVAR question? You mean you want to
know how to set environment variables?

Cheers
Colin

On Sun, 17 Apr 2022, 23:16 Jay Vaughn, <jeffersonvaughn@xxxxxxxxx> wrote:

thank you Colin... got it figured out thanks to you.

I did not have a dependent .jar file placed here...

/QIBM/UserData/OS400/SQLLib/Function/jar

works now... but on a different note... If I made changes to the WRKENVVAR
for *SYS and *JOB, how is best way to recover those changes?
Do I need a system backup for that?

Jay

On Sun, Apr 17, 2022 at 8:13 AM Colin Williams <colinwilliams007@xxxxxxxxx

wrote:

Where are you running this from?

Do a strdbg first and then run this on ibmi and if you are lucky you

might

get more information in the joblog.

If its a java udf that's dependent on another class, has the class path
been setup correctly. Have the required classes been added to the class
path?

https://www.ibm.com/support/pages/class-path-used-java-procedures

If its running fine on another system compare the setup for both and see
what's different/missing

Cheers
Colin

On Sun, 17 Apr 2022, 13:01 Jay Vaughn, <jeffersonvaughn@xxxxxxxxx>

wrote:

Thanks Colin.

Yes a valid json formatted string.
I do have the code.
Nothing more in the job log unfortunately.
I’ll try and post the extended help on the error.
I run this same udf on a different ibm i passing it the same string and

it

works fine.

I think it’s an installation or run time environment issue. But not

sure

where to go for that stuff or what to consider.

Jay

On Apr 17, 2022, at 7:00 AM, Colin Williams <

colinwilliams007@xxxxxxxxx>

wrote:

Sounds like a problem with the underlying UDF you are calling.

Do you have the code for it? Anything else in your joblog?

What is the code doing? If its processing a json file or string you

might

want to check that the format is valid.

On Sat, 16 Apr 2022, 23:41 Jay Vaughn, <jeffersonvaughn@xxxxxxxxx>

wrote:

I am personally not a knowledgeable IBM i java developer.

I can provide more info but anyone know what this may mean?

In strsql, I'm simply invoking an sql statement that calls a UDF

that

calls

a java something or the other. :)

Java stored procedure or user-defined function COREIRST.JSON2XML,

specific

name JSON2XML_CLOB aborted with an exception "org.json.JSONObject".
sqlstate 38000

tia

Jay
--
This is the Java Programming on and around the IBM i (JAVA400-L)

mailing

list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L)

mailing

list

To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our

affiliate

link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L)

mailing

list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com