WebSpeed
Developer’s Guide


DB Transactions in Code

The terms physical transaction and commit unit refer to the same concept as the WebSpeed database transaction. For example, in the previous scenario where you are adding customer records, each customer record you add is a database transaction. In Figure 9–1, each order-line you create is a database transaction.

Figure 9–1: Database Transaction Definition

The database transaction is undone (or backed out) if:

In either of these cases, WebSpeed undoes all work it performed since the start of the database transaction, as shown in Figure 9–2.

Figure 9–2: Database Transaction Undo Processing

So far, you have seen how a database transaction can be useful in a situation that involves only a single table. Database Transactions take on additional importance when you make database changes in multiple tables or records.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095