ADO, Oracle and locking

From: <smith_at_ali.com.au>
Date: 1998/03/11
Message-ID: <6e7l8b$jgr$1@nnrp1.dejanews.com>#1/1

Hi,

I am using Oracle via ADO with the Microsoft Oracle driver bundled with ADO 1.5c. My question is on the subject of locking.

What I am finding is that opening a recordset in adLockPessimistic mode does not prevent other users from updating the record, and the second user to call the update method gets either a useless error message or no message at all - the last one to do the update gets their way! Exactly the same happens with Optimistic recordsets.

Looking through the DBA views such as GV$LOCKED_OBJECT shows that no locks are placed on any objects when the recordset is opened, regardless of the lock mode specified.

Does anyone have any comments or experience of this.

Dave Smith

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 11 1998 - 00:00:00 CST