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)
