Stace:
When I read your note it prompted me with many questions. In your case, using cftransaction would appear risky for data integrity.
What database are you using? What form is the whack of orders? A flat file? What kind of batch file? Are the orders in a batch file prior to the updates or are you keeping the results of the the update in a batch file. What is the reason for rolling back all order updates if one order update fails? Does the database schema incorporate order update tracking feature? Does the update include read-after-write queries to verify the update?
I would not trust cftransaction to roll back a long update process. Begin by looking at the transaction techniques recommended with the DBMS. CFtransaction will be constrained by the capacities of the database.
Joseph
At 07:11 PM 7/16/2004, you wrote:
Hi All,
I've been sifting thru the archives for some material on transactions and CFCs (and found some). Just not sure how to apply it in a particular case.
I've got a batch process that runs nightly on one system. It loads a whack of orders in a particular state, constructs a batch file while updating the status of each order. I'd like to safeguard the process so that if there's a failure at any point, ALL db transactions are rolled back. Will that actually happen if I'm feeding multiple calls thru my DAO?
Batch Service <transaction>(loop over x orders)</transaction> -> Order Manager -> Order DAO
So if it's on order 15 for instance and an exception is thrown and I rollback from the batch service...will it actually rollback every db transaction performed in the lower extremities? Hope that made sense.
Thanks! Stace
<table width=800 cellpadding=4 cellspacing=10 border=0><tr bgcolor=BDBDBD><td valign=top width=400><font face=verdana size=2 color=FFFFFF><b>AVIS IMPORTANT</b></font></td><td valign=top width=400><font face=verdana size=2 color=FFFFFF><b>WARNING</b></font></td></tr><tr><td valign=top width=400><p align=justify><font face=verdana size=1 color=808080> Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.</td><td valign=top width=400><p align=justify><font face=verdana size=1 color=808080> The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind.</td></tr></table>
---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
----------------------------------------------------------------------- http://www.switch-box.org/CFSQLTool/Download/
Switch_box MediaFirm, Inc. www.Switch-box.org Loveland, CO USA
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
