21 Mar
2002
21 Mar
'02
4:09 p.m.
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 ?