Hi,
It seems JDBCRealm implementation calls Conneciton.setAutoCommit() method
automatically. So your MySQL Server need to be able to accept SQL statements
"SET AUTOCOMMIT=1;" or "SET AUTOCOMMIT=0;"
Please check it with mysql console client.
In my case, MySQL-Max(InnoDB) 3.23.49 and gweMys
I am using MySQL version 3.23.47 on Win ME with Apache Tomcat 4.0. I am
using JDBC realm but the error reported is :
java.sql.SQLException: Cannot disable AUTO_COMMIT
at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:396)
at org.apache.catalina.realm.JDBCRealm.open(JDB
