Re: java error

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