----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Ranga Message 6 in Discussion I have all my inserts/updates/deletes inside a transaction , and all proper rellback if any exception occurrs. WAHT I WANT IS (reason expalined below) to lock the tables immediately after begining of the transactions. Implement a retry mechanism (some way) if locking fails. If it is not feasible in a reasonable time (say 5 seconds ?) then throw an error. If all locks do succeed, I have free access to the tables and do not have to implement further locking. ACTUAL SCERNERIO: As the webservice is used by the client, biztalk throws a lot of update requests at the same time. If I have no provision for locking, a lot of them fail and are started again by the biztalk server. This can lead to so many requests the server cannot cope and it generates more and more errors If you have any idea on retry mechanism, please share the same ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
