This is a bug in the 3.0.5 mysql jdbc driver. Following is a solution to this problem...
This is fixed in what will become 3.0.6. You can test the nightly snapshot
----- Original Message -----
Sent: Thursday, February 06, 2003 12:56 AM
Subject: bug in mysql-connector-java-3.0.5-gamma?
I am using mysql-connector-java-3.0.5-gamma with mysql 3.23.55 and jboss
When connecting to mysql using a jboss pooled connection I get an error
(something to the effect of):
"cannot retrieve transaction isolation level from the server"
there is a line in Connection.java that goes like this:
"SHOW VARIABLES LIKE transaction-isolation'"
which seems to be causing the problem, since, at least with my version of
mysql, the variable is defined like this:
Since this error prohibits the connection pool from working I changed the
"SHOW VARIABLES LIKE 'transaction_isolation'"
and recompiled, and it works fine.
NOTE: This problem does not show up if I call the driver directly using: