2 Replies Latest reply on Feb 7, 2003 6:11 PM by korwin

    Bug 3.0.6 / Mysql

    jean Newbie

      Hi,
      Seems like there's a bug in jboss 3.0.6 :
      The server is generating the following SQL statement to get the transaction isolation level :

      SHOW VARIABLES LIKE 'transaction-isolation'

      This statement leads to the following exception

      java.sql.SQLException: Could not retrieve transaction isolation level from server); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not retrieve transaction isolation level from server))
      at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:106)


      The reason is because no row is returned by MySQL :

      mysql> SHOW VARIABLES LIKE 'transaction-isolation';
      Empty set (0.00 sec)


      because correct statement is :

      mysql> SHOW VARIABLES LIKE 'transaction_isolation';
      +-----------------------+------------------+
      | Variable_name | Value |
      +-----------------------+------------------+
      | transaction_isolation | READ-UNCOMMITTED |
      +-----------------------+------------------+
      1 row in set (0.00 sec)


      Hope this helps...