Subject | I need some help with Transactions |
---|---|
Author | guerrero747 <guerrero747@yahoo.es> |
Post date | 2003-02-09T10:26:08Z |
Hello!
First of all sorry for my bad english.
We are trying to run a test program that makes a couple of
connections to a database with the autocommit disable so we can work
with transactions.
Our problem is that QueryTimeout isn't working (DOC: do nothing) and
we neither know how to make that instead of "deadlock" we get an
SQLExcetion or something similar.
We readed that setting TransactionIsolation to
TRANSACTION_REPEATABLE_READ will trow it, but didn't work.
Thanks.
First of all sorry for my bad english.
We are trying to run a test program that makes a couple of
connections to a database with the autocommit disable so we can work
with transactions.
Our problem is that QueryTimeout isn't working (DOC: do nothing) and
we neither know how to make that instead of "deadlock" we get an
SQLExcetion or something similar.
We readed that setting TransactionIsolation to
TRANSACTION_REPEATABLE_READ will trow it, but didn't work.
Thanks.