Re: HTTPGETCLOB and Java

Sounds as if the SQL stuff is setting the CLASSPATH and since that is only used once per job no attempt to change it will have any impact. This would explain why it works in a batch job.

I don't know what the SQL stuff needs but it seems to me that you would need to set the class path and fire up the JVM _before_ using the SQL functions. That implies that you must find out what values the SQL http functionality requires in the path.

On Mar 5, 2021, at 5:32 PM, DEnglander--- via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

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