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)
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)