Subject | Resolving Lock conflicts on the Firebird server |
---|---|
Author | colincoleman2002 |
Post date | 2006-03-07T11:12:10Z |
Every now and then our Delphi 7 app, running against a FB 1.5.x server
decides to throw a lock conflict at the users, up till now the
solution has been for all the users to log out one by one untill the
lock is released and then they can all carry on again, bit of a pain
when 70 users plus are logged in.
Is there a way of asking the server what lock conflicts are active and
which connections caused them?
would make my life very easy then to tell the locking connection to
save / abort.
Thanks
Colin
decides to throw a lock conflict at the users, up till now the
solution has been for all the users to log out one by one untill the
lock is released and then they can all carry on again, bit of a pain
when 70 users plus are logged in.
Is there a way of asking the server what lock conflicts are active and
which connections caused them?
would make my life very easy then to tell the locking connection to
save / abort.
Thanks
Colin