Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Jdbc and Two Phase Commit Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Jdbc and Two Phase Commit" Watch "Jdbc and Two Phase Commit" New topic
Author

Jdbc and Two Phase Commit

Sujatha Kumar
Ranch Hand

Joined: Jan 05, 2004
Posts: 134
Hi,

This might be a dumb question.
But it would be great if you could share your thoughts.

Is it possible to achieve two-phase commit using pure JDBC ?

Assuming that you have two web servers supporting two different
database, In this case how can i achieve two-phase commit
across the webservers.

I was just curious about this scenario...

Regards


SCJP,SCWCD,SCBCD,SCEA Part I
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
Nope, a JDBC transaction is a local transaction. For a distributed transaction, you need JTA. You will need amongst other things, a transaction manager, XA-enabled databases and resource managers (such as XA JDBC drivers). Check your container and database documentation for details on how to get this working.


SCJP 1.4, SCWCD 1.3, SCBCD 1.3
 
jQuery in Action, 3rd edition
 
subject: Jdbc and Two Phase Commit
 
It's not a secret anymore!