Hi,

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.

john,

More than likely you can't hold steps 4 and 5 in transaction because you're
dealing with an external service. What I would do is have your payment
authorization routine write a log to the disk subsystem. If step #6 fails,
write the transaction to the log as an error. Have a reconciliation program
that allows users to manually resolve such errors.

-- Bill

<i676373 (AT) gmail (DOT) com> wrote

On Mar 5, 1:55 am, i676... (AT) gmail (DOT) com wrote:
is your web server doing the phone call and then IVR system doing the
data entry?
If it is not under your control then the user could tell your website
they paid it and you cannot verify.

So looks like NO, you cannot combine those steps into one transaction,
manually of automatically.

Ed