Transaction rollback call failed

Question

We are using sqlTransaction, if a transaction commit fails, do we need to call rollback or can we assume that a rollback would be enforced?

I am asking because a rollback can also fail if the commit fails, and doing a rollback and fail would complicate the exception handling.

Answer 1

Ingeneral a rollback will be enforced, unless the transaction is committed/completed.  You can model the transactional operation as specified here, to catch any exception in the commit call.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqltransaction.commit.aspx 

Thanks,

Srini

Answer 2

Thanks for reply, but there seems to be a problem when I applied this pattern, the rollback call causes exception because the transaction is no long valid at that point when the commit fails.

Can we simply ignore that exception in such case?