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...
SCJP,SCWCD,SCBCD,SCEA Part I
posted 11 years ago
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.