Prevent transactionion aborting when a SQLException is thrown

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chirath Fernando - 01 Dec 2004 13:28 GMT

Hi All

I have written a COM+ object using C#. The transaction option is set
as TransactionOption.RequiresNew. I do several database updations in
this class & I have observed that the transaction is automatically
aborted even though I handle SQL exceptions properly. My intention is
to try several times when a database connection fails, but firs time a
SQLException is thrown the transaction is aborted. Is there a way to
prevent this?

Thanks,
-Chiarth

Reply to this Message

Tomas Restrepo \(MVP\) - 03 Dec 2004 11:02 GMT

> I have written a COM+ object using C#. The transaction option is set
> as TransactionOption.RequiresNew. I do several database updations in
[quoted text clipped - 3 lines]
> SQLException is thrown the transaction is aborted. Is there a way to
> prevent this?

You have to retry the entire *transaction*, not just the DB operation that
failed. Once the resource manager says it can't do one operation, doesn't
matter what you do, the resource manager will still vote to abort the
transaction.

Signature

Tomas Restrepo
tomasr@mvps.org

Reply to this Message

Rate this thread:

Prevent transactionion aborting when a SQLException is thrown

Free Magazines