Locks With Dataserver Oracle

[Francisco]

Hi all,

I'm using PROGRESS 9.1C & 9.1D, ORACLE 8.1.7 on WINDOWS 2000 platform.

My problem :

Using the PROGRESS DATASERVER FOR ORACLE, i've got a problem with locking records.

I execute the same program in two PROGRESS sessions :

The program locks a record (find exclusive-lock), display the value of the 'locked table' expression (yes or no).

With a PROGRESS table, this works good (the second session is waiting for the first one to release the record).

With a ORACLE table, the record is never locked and twice sessions can perform an update.


1st progress session :

run proc-a .

message locked <table>. /* display no with an ORACLE table
display no with a PROGRESS table */
update <table> .

/*---------------*/
proc-a :
find first <table> exclusive-lock .
end.
/*---------------*/


2nd progress session :

run proc-a .

message locked <table>. /* display no with an ORACLE table
display yes with a PROGRESS table */
update <table>.

/*---------------*/
proc-a :
find first <table> exclusive-lock.
end.
/*---------------*/


Regard,
Francisco.

e-mail : f.oddono@deal.fr
--------------------------------------------------------

 

[livetocode]

Progress locking and Oracle are NOT the same - a Progress exclusive-lock will only yield a shared update lock on the Oracle side. This was true with Progress 8 and Oracle 8.