I'm just speculating, but are transactions supported in the version of MySQL
you are using?
"Park, Sung-Gu" wrote:
> The error message is like :
>
> Starting service Tomcat-Standalone
> Apache Tomcat/4.0-b4-dev
> Catalina.start: LifecycleException: Exception opening database connection:
> jav
> a.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:609)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1044)
>
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:253
> )
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:3
> 53)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:458
> )
> at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
> at org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
> at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
> at java.lang.reflect.Method.invoke(Native Method)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:179)
> ----- 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:540)
> at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:607)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1044)
>
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:253
> )
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:3
> 53)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:458
> )
> at org.apache.catalina.startup.Catalina.start(Catalina.java:718)
> at org.apache.catalina.startup.Catalina.execute(Catalina.java:640)
> at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
> at java.lang.reflect.Method.invoke(Native Method)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:179)