Re: HTTPGETCLOB and Java

from: DEnglander--- via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>
subject: HTTPGETCLOB and Java

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