Re: java error

Good that you got it figured out.

Not sure what you mean by your WRKENVVAR question? You mean you want to
know how to set environment variables?

Cheers
Colin

On Sun, 17 Apr 2022, 23:16 Jay Vaughn, <[email protected]> wrote:

> 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
>
-- 
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