[Zope] Concurrency/Atomicity in ZSQL/ZOracleDA ?

Renaud Guérin rguerin@free.fr
Thu, 21 Mar 2002 17:09:19 +0100 (MET)


En réponse à "Matthew T. Kromer" <matt@zope.com>:
> No, its not OK -- two threads executing at the same time will generate
> an identical MAX(ID) + 1.  Thats why you have to use an Oracle
> Sequence.


Ok thanks.
But as I mentioned, using a sequence is not an option for me right now.

Someone just pointed out to me that SELECT FOR UPDATE is just what I'm looking for.
I understand it may not result in optimum performance, but this is a low traffic
page and not an issue. Is it at least semantically correct ?