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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.