Subject RE: [firebird-support] Re: C# Application hangs, ... NOBODY INTERESTED IN THIS?
Author Alan McDonald
> > Hi everybody,
> >
> > e.g. performing 'update customer set accountno=3 where customer_id =
> 10001' from dbw

after doing this update in DBW, commit the update. The C# app should not
hang.
But the c# app must be trying to do an update on this record and the
transaction settings in both DBW and the c# app are in conflicvt.
Tel us more about the transaction settings on both.
Alan

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