Re: java error

Colin Williams <[email protected]> Sun, 17 Apr 2022 13:12:47 +0100
Newsgroups gmane.comp.lang.as400.java
Message-ID <CAJOH7P0NZd4upL1F56zvhaLhmcHjM0zi6doQvpnvQvGnD6g9TA@mail.gmail.com>
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, <[email protected]> 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 <[email protected]>
> 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, <[email protected]>
> 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: [email protected]
> >> To subscribe, unsubscribe, or change list options,
> >> visit: https://lists.midrange.com/mailman/listinfo/java400-l
> >> or email: [email protected]
> >> 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: [email protected]
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/java400-l
> > or email: [email protected]
> > 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: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/java400-l
> or email: [email protected]
> 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: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: [email protected]
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