tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arnaud Dostes - NTI" <ados...@nti-sa.com>
Subject Re: A latest nigtly build error with MySQL
Date Tue, 24 Apr 2001 13:06:25 GMT
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" <sponks@mozcom.com>
To: <tomcat-user@jakarta.apache.org>
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)


Mime
View raw message