Re: Specifying a JVM for JDBCR4, was Re: a problem accessing a MySQL server

On 2/20/13 3:10 PM, Scott Klement wrote:

ADDENVVAR ENVVAR(JAVA_HOME)
VALUE('/QOpenSys/QIBM/ProdData/JavaVM/jdk50/32bit')

Thanks.

I was able to successfully tell it to use Java 6. And there was a change in the behavior.

Unfortunately, not a very useful change: the stuff sent to STDOUT changed a bit, but it simply sat there for even longer, chewing on itself, before it finally started emitting multiple dumps. And the exception reported in the joblog is still:

Java exception "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Incorrect database name ''" when calling method "getPrimaryKeys" with
signature
"(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Ljava.sql.ResultSet
;" in class "java.sql.DatabaseMetaData".

(that's two apostrophes and a double quote, as the "incorrect database name.)

In an earlier experiment, I was able to determine that changing the case of the schema made no difference in the error message.

Is there a way, with either the debugger, or some addition to the service program, or what comes out STDOUT, or the dumps (which don't actually happen until the JVM crashes trying to free null), that I can find out what is actually being passed to the Java "getPrimaryKeys" method?

--
JHHL