Re: java error

Jay:

I don't think you'll "restore" the environment variables, just set them
back to what they were before you changed them using the same command.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Mon, Apr 18, 2022 at 10:19 AM Colin Williams <[email protected]>
wrote:

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