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...