Understanding Database Transactions

A database transaction allows a series of database updates to be grouped together as a single entity. The transaction can then be accepted or rejected as an entire unit to ensure that all database systems involved in the transaction remain consistent.

Enterprise applications need to be secure, reliable, and work with systems and databases that are already in place. Many enterprises have their data distributed across multiple systems, for example inventory in a stock control system and customers in a CRM system. Applications need to work with this data across multiple databases and still guarantee that any updates occur across all systems correctly. This is achieved by the use of transactions across all data stores that are used by an application.

Newlook will support transactions where they are also supported by the underlying database system. For example, IBM i database files with journaling turned on are capable of supporting transactions.

These methods/actions manage transaction processing within a DB Connection object as follows:

• BeginTrans method, DBBeginTrans action - Begins a new transaction.
• CommitTrans method, DBCommitTrans action - Saves any changes and ends the current transaction, then begins a new transaction.
• RollbackTrans method, DBRollbackTrans action - Cancels any changes made during the current transaction and ends the transaction, then begins a new transaction.

See Also

Data Access

© 2004-2021 looksoftware. All rights reserved.