--- In firebird-support@yahoogroups.com, "crizoo4712" <cstuhldreier@...> wrote:

>
> 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.
>