Hi,

I'm currently using the ado.net firebird client 2.5 and I have some problems
with the configuration of the transactions. I only found some outdated
documentation from version 1.7 on the web, so I was hoping that someone
could point me toward some up to date documentation or tell me how to solve
my problem.

What I want to achieve, is to create a transaction with the method
FbConnection.BeginTransaction(FbTransactionOptions) that
- can write data to one or more tables
- locks the tables it want to writes at the start of the transaction to
avoid deadlocks
- waits if the tables it want to use are already locked by another
transaction

I thought that I should use the following call to create the
FbTransactionOptions object:

new FbTransactionOptions()
{
        TransactionBehavior = FbTransactionBehavior.Concurrency |
FbTransactionBehavior.Wait | FbTransactionBehavior.LockWrite |
FbTransactionBehavior.Protected
}; 

But this calls throws an exception with the message "invalid parameter in
transaction parameter block". I tried several other combinations that looked
like they should make sense to me, but I got the same error every time.
Moreover, at this point, I am not too sure of how to specify which table I
want to lock. From what I read in my book about Firebird, it is possible to
do it, but I'm not sure if the data provider allows it and then how to do
it.

Thank you very much,

Marc Bettex



------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to