[Zope] Concurrency/Atomicity in ZSQL/ZOracleDA ?

[Matthew T. Kromer]

Renaud Gu=E9rin wrote:

>>ly instead of in parallel.
>>
>
>I think I need to lock the table against reads, not inserts.
>What I must ensure is that no more select's max(id)+1 can be done before=
 the
>subsequent insert is completed.
>I don't know how to use LOCK to do that, anyone ?
>
>thanks
>

You want   LOCK TABLE table IN EXCLUSIVE MODE;   most likely.  A second=20
lock statement will block until the first one clears.

--=20
Matt Kromer
Zope Corporation  http://www.zope.com/=20