Discussion:
Lock conflit.
(too old to reply)
Craig Stuntz [TeamB]
2008-02-21 20:34:02 UTC
Permalink
How can I intercept a lock conflit and to know who is the user that
lock me?
You don't. There is no way to know for sure who the user is. The best
you can do is retry your edit.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt
your DBs! Open Edition users, get 6.0.1.6 from http://mers.com
Bill Todd [TeamB]
2008-02-21 22:07:34 UTC
Permalink
How can I intercept a lock conflit and to know who is the user that
lock me?
To add to Craig's comment, if you get a 'lock conflict on nowait
transaction error' wait a few undred milliseconds and try again. Since
transactions should be very short you should not have to retry more
than once. If you have a situation where a transaction is updating a
row and not committing quickly then you need to examine your design and
change that behavior.
--
Bill Todd (TeamB)
Loading...