dbTalk Databases Forums  

MySQL JDBC driver rollback issue

mailing.database.mysql-java mailing.database.mysql-java


Discuss MySQL JDBC driver rollback issue in the mailing.database.mysql-java forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Suresh Bathini
 
Posts: n/a

Default MySQL JDBC driver rollback issue - 07-27-2004 , 03:58 PM






------_=_NextPart_001_01C4741C.7EC9D08A
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

I am using the following:

=20

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

=20

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

=20

Txn.begin();

Java.sql.Connection conn =3D ...

Txn.rollback();

=20

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?

=20

Thanks,

Suresh


------_=_NextPart_001_01C4741C.7EC9D08A--

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.