Day 13. Programming with Transactions

In the last lesson, you learned all about locking. You saw the different kinds of locks the server uses to maintain transaction isolation and how the automatic transaction mechanisms work. Today, you will see how to manage transactions and locks in your own programs.

After completing this lesson, you will be able to

• Understand automatic transaction management mechanisms

• Manage transactions in your applications

• Write effective error-handling routines

• Use alternative locking approaches with optimistic locking and application resource locking

• Understand and work around long-running transactions