[Zope] Concurrency/Atomicity in ZSQL/ZOracleDA ?

[Matthew T. Kromer]

Renaud Gu=E9rin wrote:

>But what I want to make sure is that a transaction implies atomic operat=
ion, ie
>nobody else can perform another select max(id)+1 before the select of th=
e first
>caller is performed.
>Is that OK with my current setup ?
>

No, its not OK -- two threads executing at the same time will generate=20
an identical MAX(ID) + 1.  Thats why you have to use an Oracle Sequence.

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