Re: java error

understood - thanks - but where would I reference the old values?  from a
system save?  Anything more accessible than that by chance? (hoping?)

Jay

On Mon, Apr 18, 2022 at 11:24 AM Jim Oberholtzer <
[email protected]> wrote:

> Simply use the WRKENVVAR command and add them as needed.
>
> --
> Jim Oberholtzer
> Chief Technical Architect
> Agile Technology Architects
>
>
> On Mon, Apr 18, 2022 at 10:23 AM Jay Vaughn <[email protected]>
> wrote:
>
> > No. I deleted some on accident.
> > What is best way to recover those changes?
> >
> > Tia
> >
> > Jay
> >
> > > On Apr 18, 2022, at 11: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
> >
> --
> 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