Search archives & Bugzilla, i think you can disable AUTO_COMMIT in MySQL, by just adding some params to the URL used in JDBC..
Saludos , Ignacio J. Ortega > -----Mensaje original----- > De: Ricardo Ramalho [mailto:[EMAIL PROTECTED]] > Enviado el: mi�rcoles 23 de enero de 2002 12:21 > Para: Tomcat Users List > Asunto: JDBCRealm > > > Hi ppl! > > I've configured Tomcat 4.0.1 (Windows 2000) do access a > JDBCRealm in a MySQL > database (in a Linux box). > The relevant part of the server.xml files looks like this: > > ... > <Realm className="org.apache.catalina.realm.JDBCRealm" > debug="99" > driverName="org.gjt.mm.mysql.Driver" > connectionName="kossa" > connectionPassword="kossa" > connectionURL="jdbc:mysql://192.168.1.2:3306/kossa_test" > userTable="users" userNameCol="user" > userCredCol="passwd" > userRoleTable="user_roles" roleNameCol="role_name" /> > ... > > When i try to launch Tomcat it echoes out an exception like this: > ... > 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.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService > .java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at > org.apache.catalina.startup.Catalina.start(Catalina.java:776) > at > org.apache.catalina.startup.Catalina.execute(Catalina.java:681) > at > org.apache.catalina.startup.Catalina.process(Catalina.java:179) > at java.lang.reflect.Method.invoke(Native Method) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) > ... > > What is goin on? :( > > > ------------------------------------------------- > Ricardo Ramalho > ------------------------------------------------- > > > > -- > 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]>
