You sure need to review your application design and business
rules to avoid pessimistic locks and the nightmare related to
them. The longer the locks, the more resources you are going to
consume. Alex's article is the best reference available to read
more about that.





--- Stevio <redeagle@...> escreveu: > I am using Delphi
5 with Firebird 1 and Interbase Express 5

> components.
>
> With my application, I use a simple locking mechanism to lock
> a record when
> a user has it open.
>
> Basically:
> - a transaction is started,
> - the record in question is opened using a TIBDataSet,
> - the record is put in edit mode,
> - the id value for the record is set to itself.
> - the change is posted.
> - the TIBDataSet is closed.
> - the transaction is not committed however until the user
> makes their
> changes to the data and clicks OK.
>
> My problem is that the system is hanging occasionally for some
> reason (not
> sure why), and when they CTRL ALT DEL to close it and restart
> it, records
> are being left locked for weeks at a time. (I'm not sure how
> they are
> eventually released - perhaps if the server is rebooted they
> get released
> then?)
>
> How can I manually release the lock, or override the lock, on
> a record when
> I have no access to the original transaction?
>
> Thanks,
> Stephen
>
> ------------------------ Yahoo! Groups Sponsor

______________________________________________________________________

Yahoo! Mail: 6MB, anti-spam e antivírus gratuito! Crie sua conta agora:
http://mail.yahoo.com.br