tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Jacobson <marti...@libero.it>
Subject Re: tomcat, tyrex and mysql
Date Fri, 31 Jan 2003 16:10:40 GMT
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



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message