Re: JDBCR4 - very occasional Java exception on JDBC_Properties() call.

Gerald,

What this tells you is that when calling the prepareStatement Java method (a routine in the JDBC driver) it is internally trying to call something named "com.mysql.jdbc.EscapeProcessor", but can't find it.

This is all happening inside the JDBC driver. JDBCR4 calls the prepareStatement method of whichever driver you've loaded, but cannot control what the prepareStatement method does under the covers.

Possibly you are missing some JAR file in your CLASSPATH? Or possibly this is a bug in the MySQL JDBC driver you're using?

-SK


On 11/22/2016 1:45 PM, Gerald Magnuson wrote:

wait, I found an exception error above this...
Message . . . . : Java exception received when calling Java method.

Cause . . . . . : RPG procedure JDBC_PREPS in program JDBC2LIB/JDBCR4

received Java exception "java.lang.NoClassDefFoundError:

com.mysql.jdbc.EscapeProcessor" when calling method "prepareStatement"
with
signature "(Ljava.lang.String;)Ljava.sql.PreparedStatement;" in class

"java.sql.Connection".

On Tue, Nov 22, 2016 at 1:25 PM, Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx

wrote:

strangely this problem seems to come and go, and I can't figure out how to
replicate for testing.

I have a MCH3601 "pointer not set" error which appears to be in QXJ9INI
program
"AttachCurrentThread__FP7JavaVM_PP7JNIEnv_Pv" procedure...
called from JDBCR4 program, JDBC_Properties procedure...

does anyone know how I can trace or catch these errors?