Help using JDBC realm with MySQL

[Shawn A. Wilson]

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&amp;password=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.java:39)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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.java:39)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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]>