• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Transaction Processing > Looking at Transaction Processing Issues

Looking at Transaction Processing Issues

Before you decide that transaction processing is the best thing since sliced bread, you should keep in mind several issues concerning transaction processing. This section outlines these issues.

Realizing That Transactions Occur in a Workspace

Transactions exist in the context of a Connection object. The BeginTrans, CommitTrans, and RollbackTrans methods affect all operations on the specific connection. If you want simultaneous, unrelated transactions to be in effect, you must create separate Connection objects in which the transactions are applied. Whereas data access objects (DAO) supported transactions that spanned multiple databases, ADO transactions are limited to a specific data source because they exist in the context of a connection.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint