Exception: Using JDBC Realm with mysql server in win2000

Tony Lu Fri, 07 Dec 2001 05:39:06 -0800

I am using this driver,mm.mysql-2.0.4-bin.jar, to connect to mysql server. however, I cannot start the server when I use the JDBCRealm. I got the exception:

Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Catalina.start: LifecycleException: Exception opening database connection: java.sql.SQLException: Cannot disable AUTO_COMMIT
LifecycleException: Exception opening database connection: java.sql.SQLExcepti
on: Cannot disable AUTO_COMMIT
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
        at org.apache.catalina.core.StandardService.start(StandardService.java:388)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at java.lang.reflect.Method.invoke(Native Method)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
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)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Exception: Using JDBC Realm with mysql server in win2000

Reply via email to