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]
