Re: java error

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