Locking and RowID

[AlexMatsuka]

There is such problem: when two users works with app and make insert into updatable dataset then one app delayed until another commit. It's appears after upgrading to Oracle 9.2.0.7 from 8.1.7

DOA 4.0.5 How can we fix it?

 

[Marco Kalter]

If LockingMode is set to lmLockImmediate, lmCheckImmediate, or lmLockDelayed, then the dataset will implicitly check for a lock before updating a record.

If you explicitly execute (e.g. ExecSQL) an update table statement through a dataset, then you must also explicitly check for a lock. You can do so by first executing a "select ... for update nowait" statement. If it succeeds, you have a lock. If it fails, the record was locked by another session.