i haven't had that problem - but i don't specify login credentials in my
realm connection. could be the grants assigned to your login.
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://localhost/securityDB"
userTable="users" userNameCol="username"
userCredCol="password"
userRoleTable="userroles" roleNameCol="userrole" />
-----Original Message-----
From: Shawn A. Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 2:33 PM
To: Tomcat Users List
Subject: Re: Help using JDBC realm with MySQL
Does nobody know a solution to get around this problem? I have received
no
replies and I desparately need to know how to get around the "Cannot
disable AUTO_COMMIT" error with JDBC realms and MySQL.
Thanks,
-shawn
http://www.shawn-wilson.com
On Wed, 10 Apr 2002, Shawn A. Wilson wrote:
> Please help, I'm using Tomcat 4.0.2 and am trying to setup a JDBC
realm
> with MySQL. Here is the snippet from server.xml:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
> driverName="org.gjt.mm.mysql.Driver"
>
connectionURL="jdbc:mysql://localhost/peopleshare?user=hidden&passwo
rd=hidden"
> userTable="users" userNameCol="user_id" userCredCol="password"
> userRoleTable="user_roles" roleNameCol="role_id" />
>
> And here is the exception stack trace:
>
> Starting service Tomcat-Standalone
> Apache Tomcat/4.0.2
> Catalina.start: LifecycleException: Exception opening database
> connection: java.sql.SQLException:
> Cannot disable AUTO_COMMIT
> LifecycleException: Exception opening database connection:
> java.sql.SQLException: Cannot disable A
> UTO_COMMIT
> at
org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
> at
>
org.apache.catalina.core.StandardService.start(StandardService.java:388)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
> at
org.apache.catalina.startup.Catalina.start(Catalina.java:781)
> at
org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
> at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
> at
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
> ----- 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:549)
> at
org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343)
> at
>
org.apache.catalina.core.StandardService.start(StandardService.java:388)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
> at
org.apache.catalina.startup.Catalina.start(Catalina.java:781)
> at
org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
> at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
> at
>
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
> at
>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
>
>
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
