A latest nigtly build error with MySQL
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)
Re: A latest nigtly build error with MySQL
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)
Re: A latest nigtly build error with MySQL
Transactions ARE NOT supported on mySQL. On the latest versions, transaction-like actions can be performed, but you got to use special workarounds. I recommend reading the doc on mysql.com on transactions. - Original Message - From: "Noel E. Lecaros" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 24, 2001 2:56 PM Subject: Re: A latest nigtly build error with MySQL > 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)