optimistic locking
Posted: Mon 14 Aug 2006 11:33
HOW CAN I USE THE optimistic locking IN ORACLE??
Devart Forums
Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
optimistic locking
Page 1 of 1
Posted: Tue 15 Aug 2006 08:24
TOraQuery, TSmartQuery, TOraTable components have LockMode property which can be set in lmNone or lmDelayed for optimistic locking.
optimistic locking
Posted: Wed 16 Aug 2006 07:35
sorry i don´t understand you. you say that "lmDelayed" LockMode is for the optimistic locking???
Posted: Wed 16 Aug 2006 10:02
Yes, lmLockDelayed is used for optimistic locking. In that case dataset executes SELECT FOR UPDATE NO WAIT query just before posting changes to be sure that the record is not locked.
Also you should set CheckMode property to cmException. In that case the dataset checks if the record wasn't changed by another user, otherwise it generates an exception.
Also you should set CheckMode property to cmException. In that case the dataset checks if the record wasn't changed by another user, otherwise it generates an exception.
Posted: Wed 16 Aug 2006 12:01
OK THANKS, NOW IS PERFECT!!!! 