Re: HTTPGETCLOB and Java

I wonder if this APAR would help the issue.
https://www.ibm.com/support/pages/apar/SE74466
R730 SI75433
R740 SI75437

Problem Conclusion
The problem occurs in some cases because the initialization of
the CLI environment by the native JDBC driver causes problems
for NOT FENCED Java UDFs.
The native JDBC driver has been update to initialize the CLI
environment in a different manner when it is used in the Java
UDF and Java stored procedure environment.


maybe, just the latest I saw related the HTTP sql functions

Bryan



DEnglander--- via RPG400-L wrote on 3/10/2021 7:58 AM:

Jon,

Thank you for that information! I researched what the class path is for
the java email program, and added it to the CLLE before the first
HTTPGETCLOB executed. It still crashed. But what I did do was to add a new
parameter value to the email process that allows it to be run on the JOBQ
rather than in-line. Once I got that changed, I was able to run all 4
programs back to back in one CLLE and receive their reports via email.

I didn't know about the Class Path only being set once. Good to know about
that.

Thanks again,

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."