Waiting transaction (with Firebird database)

30 views
Skip to first unread message

MKR

unread,
Feb 10, 2012, 4:59:25 PM2/10/12
to nhusers
I need a non-blocking transaction and the default behavior (at least
for Firebird) is that the transaction will wait forever if another
transaction has locked a row.

Is it possible to do one of the following:
1) Specify that the transaction should NOT wait for locks to be
released (instead it should throw a deadlock exception)?
2) Manually create a Firebird Transaction and attach it to the
ISession?

Or better yet:
3) How do I specify FbTransactionOptions.NoWait when using
ISession.BeginTransaction?

See http://web.firebirdsql.org/dotnetfirebird/documentation/api/1.7/FirebirdSql.Data.Firebird.FbTransactionOptions.html
for docs.
Reply all
Reply to author
Forward
0 new messages