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

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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?