Multiuser issue

donok · Post by **donok** » Fri 17 Jun 2011 08:09

I am using Oracle XE with ODAC ver 7.20.0.6 and Delphi XE
In a multiuser situation sometimes(quite often, but not always) a user is not notified that another is editing that record and allows that user to proceed with the obvious consequences. The component used is TsmartQuery configured as follows: LockMode:lmLockImmediate, CheckMode:cmException, AutoCommit:True. FetchRows=1. As I have been unable to replicate the problem every time, it has proved impossible to solve. Any suggestions would be welcome.

AlexP · Post by **AlexP** » Fri 17 Jun 2011 10:20

Hello,

I cannot reproduce the problem.
If I try to edit a record (that is being edited), the ORA-00054 error always occurs.
You can try to block records yourself using the For Update nowait construction

Code: Select all

select * from table WHERE ID = 1 for update nowait

If you can, create a small test project demonstrating this problem and send it to alexp*devart*com.