21 Mar
2002
21 Mar
'02
3:33 p.m.
Renaud Guérin wrote:
But what I want to make sure is that a transaction implies atomic operation, ie nobody else can perform another select max(id)+1 before the select of the first caller is performed. Is that OK with my current setup ?
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. -- Matt Kromer Zope Corporation http://www.zope.com/