Re: java error

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