O'Reilly logo

Pro ODP .NET for Oracle Database 11g by Edmund Zehoo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Transactions with ODP.NET

When programming systems with data distributed in different locations, your application must take on the responsibility of managing data integrity. In complex systems, such as those of a financial institution, applications have to frequently update data that resides in different databases. If something goes wrong somewhere in the chain, chaos can ensue if nothing is done to ensure that data integrity is maintained.

For example, if you were updating the address of a customer in three different databases, the operation can only be considered complete if all three databases were updated. If any one of these three updates failed, the updates that were successfully done on the other two databases must also be undone. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required