From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Korwin Smith" <[EMAIL PROTECTED]> Subject: Re: bug in mysql-connector-java-3.0.5-gamma? Date: Thu, 6 Feb 2003 08:32:05 -0600 X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-Virus-Scanned: by AMaViS perl-11 (thematthews.org)
This is fixed in what will become 3.0.6. You can test the nightly snapshot from http://mmmysql.sourceforge.net/snapshots/ -Mark ----- Original Message ----- From: Korwin Smith To: [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 12:56 AM Subject: bug in mysql-connector-java-3.0.5-gamma? Mark, I am using mysql-connector-java-3.0.5-gamma with mysql 3.23.55 and jboss 3.0.6. 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: "transaction_isolation" Since this error prohibits the connection pool from working I changed the line to: "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: Class.forName(com.mysql.jdbc.Driver); hopefully this is useful to you, thanks for making your driver available! korwin ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
