If you are running Tomcat 4.1.x you should be using DBCP for database connections.
Tyrex is no longer used as of 4.1 -----Original Message----- From: emiliano albiani [mailto:[EMAIL PROTECTED]] Sent: Montag, 03. Februar 2003 10:57 To: Tomcat Users List Subject: tomcat, tyrex and mysql, and autocommit Martin Jacobson wrote: > emiliano albiani wrote: > >> HI, I'm trying configuring tyrex in my tomcat installation to use >> MySql xa driver. >> I did it as described in tomcat documentation: >> http://jakarta.apache.org/tomcat/to...les-howto.html, >> ><http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html,> > >> but something is going wrong. >> > <snip> > > >> Error trace: >> >> 2003-01-31 12:04:24,631 ERROR [Thread-3](ConnectionPool.java:1046) - >> Error attempting to destory connection XAConnection: unused by >> connection pool iseDatasource >> java.sql.SQLException: Can't call commit when autocommit=true >> at com.mysql.jdbc.Connection.commit(Unknown Source) >> at com.mysql.jdbc.xa.XAConnectionImpl.close(Unknown Source) >> at tyrex.resource.jdbc.ConnectionPool.discard(ConnectionPool.java:1042) >> at tyrex.resource.jdbc.ConnectionPool.release(ConnectionPool.java:852) >> at >> tyrex.resource.jdbc.ConnectionPool.connectionErrorOccurred(ConnectionPool.java:636) >> >> at com.mysql.jdbc.xa.XAConnectionImpl.getConnection(Unknown Source) >> at >> tyrex.resource.jdbc.ConnectionPool.getConnection(ConnectionPool.java:427) >> >> at >> tyrex.resource.jdbc.ConnectionPool.getConnection(ConnectionPool.java:398) >> > > > By default MySQL is in autocommit mode - you should turn it off to > enable transactions. > > Martin How can I do it? This is what I did with no success: >mysql ise >set autocommit=0; but tyrex still have the same problem. What am I missing? Thanks in advance. Emiliano. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
