Re: java error

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