Re: Oracle 10 + Sun App Server 7: Unique Constraint Violation?!?

From: Thomas Kellerer <TAAXADSCBIXW_at_spammotel.com>
Date: Wed, 15 Nov 2006 23:23:28 +0100
Message-ID: <4s1ia0Fsan4nU1@mid.individual.net>

joeNOSPAM_at_BEA.com wrote on 15.11.2006 23:00:
>
> But if his external client queries for a sequence value, does
> Oracle guarantee that a given value will only be returned
> to one query?

Yes, absolutely. That's what sequences are for. Actually Oracle guarantees that a single value from a sequence will *never* be returned twice regardless on how many concurrent sessions or threads are calling nextval.

> If so, then it could be a client thread-safety
> issue where multiple threads are setting the same
> client variable with their (different) query values, but then
> they all use the one that is set by the slowest involved
> thread...

Sounds like a reasonable thing to test

Thomas Received on Wed Nov 15 2006 - 16:23:28 CST