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 gweMysql JDBC Driver and Tomcat4.0.3, JDBCRealm works fine. Thanks. Anupam De wrote: > > 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(JDBCRealm.java:549) > at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) -- Borland / Japan TAKAHASHI,"KEN",Tomohiro --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
