Transaction management in Spring

[venkata Silla]

Hi Team,

Let me share my recent interview experience which is a scenario driven. "Assume I have 4 database update operations( 2 SQL Server and 2 Oracle DB).Lets say the first DB SQL updates went fine which are hitting to SQL Server and while running the second DB SQL Query(Oracle) I got a system exception.How do I rollback the SQL update happened on my first database. Since I use different JDBC Connections for both. How do I rollback the changes which were happened on the First DB with out any code change and throw an exception saying system error using spring transactional management.

Thanks a lot for sharing your expertise.


Venki-

[Tim Holloway]

This is the difference between regular transactions and XA transactions.

XA transactions can actually cover not only JDBC requests to different targets, but more general mechanisms as well.

As for XA in Spring, it's supported, but I've never been called on to use it. I have a book on my shelf that's dedicated to nothing but Java transactions, and I'm not even sure it got into Spring.