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 <[email protected]>
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, <[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
>
-- 
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