Page 1 of 1
Locking referential table
Posted: Tue 04 Jul 2006 10:30
by Samuel
I am using ODAC 5.5 for Delphi 7. Here I have two table A and B where A has a referential key to B. While I start a transaction and try to edit a record in table A, it is OK that it acquires a row exclusive lock on table A. But I found that it also get a lock on table B. How to avoid locking the referential table? thanks.
Posted: Mon 10 Jul 2006 09:03
by Plash
We cannot reproduce the problem. Please specify full version of ODAC including build number (see Odac\About ODAC in Delphi menu). If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.
Locking tables
Posted: Fri 23 Feb 2007 20:49
by HDumas
Hi...
We have been working on this exact same problem for a while now... It is very difficult to reproduce. When this happens, our DBA looks into Oracle to see where it locks and what kind of a lock and which user is blocking all the other users... and the blocking in Oracle defies all logic... It shows a lock on the row, but for some reason, it seems to lock the whole table.
We are also using Delphi 7 with ODAC 5.50.0.15 with OraTools AddIn 2.60.2.17.
Would you know more about this problem??
H. Dumas