A long time ago, we put some .jar files in the following directory so that we didn't have to specify class path to load them. I do regret this now, because they load whenever anything Java runs, which you don't want sometimes. However, if you like getting things done today and regretting it later, you could try it.
/QIBM/UserData/Java400/ext
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of DEnglander--- via RPG400-L
Sent: Friday, March 5, 2021 5:32 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: DEnglander@xxxxxxxxxxxxxxx
Subject: HTTPGETCLOB and Java
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
We are on V7R3, and fairly current PTFs. I am seeing this issue:
I have an RPG program ["A"] that contacts a Web service and downloads JSON. I am using SQL's HTTPGETCLOB to retrieve the JSON, and then using JSON_TABLE to unpack the JSON. All is well, and it works fine. I read that for these abilities, SQL is using Java behind the scenes. This program puts the received data in a table for further processing.
The A program ends, and is followed by another one ["B"] that reads the table, validates the data, and loads it into another table. The B program generates a PRTF and then converts that to a PDF. Then as it finishes, it attempts to use our internal java email program to send the PDF as an attachment. This java email has been working on production and dev for years. When program B tries to send the email, the java crashes with "java.lang.NoClassDefFoundError". However, when program B is submitted to the QBATCH JOBQ, it runs fine and sends the report.
Does anyone know where I can find what the SQL functions are doing to the java environment to make this happen? I would prefer to run programs A and B inline in a CLLE, but will submit program B to the JOBQ if that is the only way to get it to work. My gut tells me that SQL is doing something to the java environment, but I don't know what it is doing. I've tried to reset the Environment Variables, but it still crashes.
Any idea what I would need to do to allow the two programs to run inline together in a CLLE?
Thank you,
Doug
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
