| Subject | C# Application hangs, table locked by another update transaction |
|---|---|
| Author | crizoo4712 |
| Post date | 2010-06-22T06:26:56Z |
Hi everybody,
e.g. performing 'update customer set accountno=3 where customer_id = 10001' from dbw causes a c# windows application to hang when attempting to access that record.
Even when the app tries to access ANOTHER customer of the same table it hangs, so complete table lock!
as soon as the other transaction commits or rolls back, the c# app comes back.
there is NO specific transaction setting in the app.
obviously it uses the default settings, but what are these?
can they be set anywhere? nothing in firebird.conf.
it seems to run in wait mode.
sometimes mon$transactions shows mon$isolation_mode 2, sometimes 3.
who can help?
regards, cs.
e.g. performing 'update customer set accountno=3 where customer_id = 10001' from dbw causes a c# windows application to hang when attempting to access that record.
Even when the app tries to access ANOTHER customer of the same table it hangs, so complete table lock!
as soon as the other transaction commits or rolls back, the c# app comes back.
there is NO specific transaction setting in the app.
obviously it uses the default settings, but what are these?
can they be set anywhere? nothing in firebird.conf.
it seems to run in wait mode.
sometimes mon$transactions shows mon$isolation_mode 2, sometimes 3.
who can help?
regards, cs.