× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Unfotunately the IBMi HTTP* services that use Java are incompatible with
your custom Java. IBM ignores the CLASSPATH when starting the JVM, so if
they start the JVM then your Java will fail. If your code starts the JVM,
then IBM's Java will fail.

See RFE:
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=130541

:(

date: Fri, 5 Mar 2021 16:32:13 -0600
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



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.