Subject Question on SELECT WITH LOCK
Author Jacob Alberty
I've got an application that uses SELECT WITH LOCK style queries to lock
records, all works great untill the program crashes with a record
locked, it will leave the record locked, is there a way to make firebird
unlock records that were locked by clients that are now disconnected
through crash or whatnot? Usually when I have trouble with locked
records, they go away when everyone has completely disconencted, or if I
shut down the database. Unfortunately neither of these solutions work
during work hours are there any other solutions to fixing this? I've
been contemplating writing a middleware app to interface with the
firebird database and my program and just handle record locking there so
that I can explicitaly unlock them, while I ultimately will do this, it
takes time and it would be nice if I could get a solution to this up sooner.