Re: Help using JDBC realm with MySQL
I had the same problem in Windows 2000 and InnoDB tables, the relaxautocommit worked but the parameter has a leading UNDERSCORE: jdbc:mysql://localhost/peopleshare?_relaxAutocommit=trueetc... I found it by code inspection. I don't know if it works under Linux, I'm still fighting with access control problems, but it should work. Shawn A. Wilson wrote: Well, I tried adding the relaxAutocommit=true parameter but I still get the same message. Arg... this is not making any sense. Do my tables need to be of a specific type? I created them without any options so they should be MyISAM. -shawn http://www.shawn-wilson.com On Thu, 11 Apr 2002, Dennis Doubleday wrote: Add the following parameter to your connection URL: relaxAutocommit=true So it should look like: jdbc:mysql://localhost/peopleshare?relaxAutocommit=trueuser=hiddenpass word=hidden -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. -- 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] -- Fabrizio Giudici, Ph.D. - Senior Consultant Java(TM) Architect, Mentor, Senior Writer email [EMAIL PROTECTED] mobile +39 3481506941 - fax +39 (0)2700510536 Member of ADI (Italian Ph.D. Association)
RE: Help using JDBC realm with MySQL
Sorry, if relaxAutocommit didn't work for you, I'm stumped. I was getting the same exception until I added the parameter. Now, I wasn't using JDBC realm...but that's why the parameter is provided, to prevent that error. -Original Message- From: Shawn A. Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 9:12 PM To: Tomcat Users List Subject: RE: Help using JDBC realm with MySQL Well, I tried adding the relaxAutocommit=true parameter but I still get the same message. Arg... this is not making any sense. Do my tables need to be of a specific type? I created them without any options so they should be MyISAM. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Help using JDBC realm with MySQL
Try the latest version of the driver r, Hugh - Original Message - From: Shawn A. Wilson [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 8:11 PM Subject: RE: Help using JDBC realm with MySQL Well, I tried adding the relaxAutocommit=true parameter but I still get the same message. Arg... this is not making any sense. Do my tables need to be of a specific type? I created them without any options so they should be MyISAM. -shawn http://www.shawn-wilson.com On Thu, 11 Apr 2002, Dennis Doubleday wrote: Add the following parameter to your connection URL: relaxAutocommit=true So it should look like: jdbc:mysql://localhost/peopleshare?relaxAutocommit=trueuser=hiddenpass word=hidden -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. -- 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]
Re: Help using JDBC realm with MySQL
Oh the simplest things are often the overlooked. I can't believe... I don't remember where I got this driver but it was extremely old (v1.2c)! Thanks for the help, -shawn http://www.shawn-wilson.com Hugh Brien wrote: Try the latest version of the driver r, Hugh - Original Message - From: Shawn A. Wilson [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 8:11 PM Subject: RE: Help using JDBC realm with MySQL Well, I tried adding the relaxAutocommit=true parameter but I still get the same message. Arg... this is not making any sense. Do my tables need to be of a specific type? I created them without any options so they should be MyISAM. -shawn http://www.shawn-wilson.com On Thu, 11 Apr 2002, Dennis Doubleday wrote: Add the following parameter to your connection URL: relaxAutocommit=true So it should look like: jdbc:mysql://localhost/peopleshare?relaxAutocommit=trueuser=hiddenpass word=hidden -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. -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Help using JDBC realm with MySQL
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=hiddenamp;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]
RE: Help using JDBC realm with MySQL
Add the following parameter to your connection URL: relaxAutocommit=true So it should look like: jdbc:mysql://localhost/peopleshare?relaxAutocommit=trueuser=hiddenpass word=hidden -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. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Help using JDBC realm with MySQL
Well, I tried adding the relaxAutocommit=true parameter but I still get the same message. Arg... this is not making any sense. Do my tables need to be of a specific type? I created them without any options so they should be MyISAM. -shawn http://www.shawn-wilson.com On Thu, 11 Apr 2002, Dennis Doubleday wrote: Add the following parameter to your connection URL: relaxAutocommit=true So it should look like: jdbc:mysql://localhost/peopleshare?relaxAutocommit=trueuser=hiddenpass word=hidden -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. -- 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]
Help using JDBC realm with MySQL
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=hiddenamp;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]