You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@tomcat.apache.org by "Park, Sung-Gu" <je...@thinkfree.com> on 2001/04/21 15:46:43 UTC

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

Posted by Arnaud Dostes - NTI <ad...@nti-sa.com>.

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" <sp...@mozcom.com>
To: <to...@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)

Re: A latest nigtly build error with MySQL

Posted by "Noel E. Lecaros" <sp...@mozcom.com>.

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)