MySQL JDBC driver rollback issue - Suresh Bathini - com.mysql.lists.java

1 message in com.mysql.lists.javaMySQL JDBC driver rollback issue

From	Sent On	Attachments
Suresh Bathini	27 Jul 2004 13:58

Subject:	MySQL JDBC driver rollback issue
From:	Suresh Bathini (sbat...@macrovision.com)
Date:	07/27/2004 01:58:18 PM
List:	com.mysql.lists.java

I am using the following:

* MySQL JDBC driver 3.0.9 * JOTM Transaction Manager * Enhydra StandardXADataSource

I was expecting the JDBC connections to auto enlist with the transaction manager if the thread is in a transaction.

Txn.begin();

Java.sql.Connection conn = ...

Txn.rollback();

I noticed that the connection returned has the auto commit turned on (true) and hence all inserts on the connection are auto committed. Do I need to explicitly register the JDBC connections with the transaction manager?

Thanks,

Suresh