scottklement.com

Scott, you suggestion below worked to increase the heap size. Thank you for all your help.



ADDENVVAR ENVVAR(QIBM_RPG_JAVA_PROPERTIES) VALUE('-Xms4096M;-Xmx6144M;')

thank you Scott, I will try this tonight.

Sorry Scott, when I said it worked that was in test but when I placed the code in production it failed on the same error OutOfMemory. This is what I placed in my CL before I call the RPG ADDENVVAR ENVVAR(JAVA_HOME) VALUE('/QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit') REPLACE(*YES) ADDENVVAR ENVVAR(CL...

Thank you , worked.

We upgraded to a new version of Oracle and because of that we had to upgrade our JDBC driver from ojdbc14.jar (1.4) to ojdbc8.jar. we are now getting this error below. IBM is saying we need to use the 64 bit ojdbc8.jar. Any thoughts? From IBM we are running java 8 32 bit JVM and specifying a maximum...

Sorry , I meant ojdbc8.jar which is the new driver that we need for Oracle 19. The ojdbc14.jar was casuing us problems. Ok, thank you Scott.

I am using the JDBC_PrepStmt to access Oracle from the AS400 using a jdbc8 driver. If my sql statement uses no where clause it runs fine . If I include parameters then I get no results. I know I should get data because I execute the statement in Oracle first. Is there a way to view the actual sql st...

We also upgraded to Oracle 19. We had to go from jdbc14 to jdbc8 for our AS400.

Is there a way to create an ODS file in rpgle?