Subject | Re: [firebird-support] Deadlock when 2 session update the same 01 row |
---|---|
Author | André Knappstein |
Post date | 2012-11-28T10:50:20Z |
>> FbTransactionBehavior t_behaviour;Depends on the transaction it should be applied to, A or B :-)
>> FbTransactionOptions t_options;
>>
>> t_behaviour = FbTransactionBehavior.NoWait;
>> t_options.TransactionBehavior = t_behaviour;
>>
>> FbConnection conn = new FbConnection();
>> conn.BeginTransaction(t_options);
>>
> should that be t_behaviour = FbTransactionBehavior.Wait?
Seriously, I thought that "Wait" is default and that this default
leads to a behaviour the OP wanted to change. It is not clear for me,
what exactly is meant by "deadlock".
Personally, if I had this problem, I'd probably want to have "NoWait",
raise an exception, catch and deal with it.
have fun!
André