how to code a transaction.

How do I manually code an atomic transaction, given the following scenario?

1. User need to pay a fine.
2. User log into the system.
3. User click the pay button.
4. User pay by a custom payment methods called NETS (system operated through telephone line, in Singapore; it is not direct connection to a databse, but somekind of services.)
5. Payment/NETS transaction done; transaction cannot rollback after this.
6. System would update the database to indicate the fine have been paid.

But step 6 might fail. How do I ensure that all the steps is in one single transaction?
Is there any example/web page which show how to program a atomic transaction manually?

Thanks

regards,
john. Received on Tue Mar 06 2007 - 02:23:47 CET