tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Roberts, Eric" <Eric.Robe...@one.at>
Subject RE: tomcat, tyrex and mysql, and autocommit
Date Mon, 03 Feb 2003 09:59:13 GMT
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:emilianoalbiani@netscape.net]
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
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