Java Mailing List Archive

http://www.gg3721.com/

Home » users.openjpa »

Re: sql ordering

Pinaki Poddar

2008-08-25

Replies: Find Java Web Hosting

Author LoginPost Reply

Hi,
> That's great news; I did not think unique constraints had been fixed.

Nope. Unique constraints can be placed by annotations/xml descriptors. But
the topological sorting algorithm that imposes an order on sql statements to
satisfy both database constraints and object-level operations do not
consider unique constraints.

So if a transaction removes x1 and inserts x2 while x1 and x2 has the same
value for a unique non-primary column then OpenJPA *does not* ensure that
DELETE x1 will be issued before INSERT x2.

--
Sent from the OpenJPA Users mailing list archive at Nabble.com.

©2008 gg3721.com - Jax Systems, LLC, U.S.A.