topic Re: Lock mode in Application Development and Automation Discussions

Lock mode

Former Member — Sun, 20 Dec 2009 14:18:18 GMT

Hi all

when i locked a table with mode 'S', another user attemp for mode 'E'.

and my mode 'S' was cancelled.

Kindly explain what has actually happened ?

Former Member — Sun, 20 Dec 2009 14:22:30 GMT

S : Shared lock

E: Exclusive lock .

The issue reported should not happen because an exclusive lock set on an object that already has a shared lock will be rejected.

Hence , there are chances that your S lock is released and then new lock in E mode happens.

Check this link

Edited by: Harsh Bhalla on Dec 20, 2009 7:53 PM

Former Member — Sun, 20 Dec 2009 15:25:32 GMT

If a data record is locked in Mode 'S' and no further read locks are set by other users,

a lock attemp in Mode 'E' is possible.This generates a second entry in the lock table.

This is what has happened in your case.

matt — Sun, 20 Dec 2009 21:20:00 GMT

Hi Vicky, Subin.

Your behaviour has been noticed. Bye bye.

matt