Managing Transaction Scope

An application that will interact with any type of data repository can face the somewhat daunting task of managing the transaction scope. Transaction scope is the entire process of establishing a database connection, communicating with the resource at the end of the connection, eventually committing any changes made, and then closing the connection.

Managing transaction scope is more difficult if the scope crosses physical database boundaries. For example, suppose that a transaction must update both an Oracle database and a Microsoft SQL Server database within the scope of one transaction and ensure that both servers are updated at the end of the transaction. This is difficult to do because talking to each database ...

Get Developing Applications with Java™ and UML now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.