tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From emiliano albiani <emilianoalbi...@netscape.net>
Subject tomcat, tyrex and mysql, and autocommit
Date Mon, 03 Feb 2003 09:56:36 GMT


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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message