SQL ordering and foreign key constraints

2007-04-25 Thread Reece Garrett
Hello,   I came accross a problem where my foreign key constraints were being violated because of the SQL insertion order during merge operations. I am aware that OpenJPA does not do any SQL re-ordering to avoid violating foreign key constraints, however, it was trivial to make the needed cha

RE: SQL ordering and foreign key constraints

2007-04-24 Thread Patrick Linskey
- > From: Reece Garrett [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 24, 2007 3:59 PM > To: open-jpa-dev@incubator.apache.org > Subject: SQL ordering and foreign key constraints > > Hello, > > I came accross a problem where my foreign key constraints > were being vi

SQL ordering and foreign key constraints

2007-04-24 Thread Reece Garrett
Hello, I came accross a problem where my foreign key constraints were being violated because of the SQL insertion order during merge operations. I am aware that OpenJPA does not do any SQL re-ordering to avoid violating foreign key constraints, however, it was trivial to make the needed changes i