Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with foreign key constraints

2006-09-12 Thread Abe White
- When you delete a parent object and the operation cascades to children, the object-level operation order is delete parent, then delete children. In my experience, the cascade should delete the children first. This solves 99% of the cascade delete issues. It seems to me you'd just

Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with foreign key constraints

2006-09-12 Thread Craig L Russell
Hi Abe, On Sep 12, 2006, at 9:21 AM, Abe White wrote: - When you delete a parent object and the operation cascades to children, the object-level operation order is delete parent, then delete children. In my experience, the cascade should delete the children first. This solves 99% of

Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with foreign key constraints

2006-09-12 Thread Abe White
I think that cascade delete is most commonly used where there is a one-to-possibly-zero relationship (with a [zero or one or many]-to- one on the other side). Thus, the other side has the foreign key, and the side with the cascade delete definition is the side with the existence that

Re: [jira] Resolved: (OPENJPA-39) Cascade delete does not work with foreign key constraints

2006-09-11 Thread Craig L Russell
Hi Abe, - When you delete a parent object and the operation cascades to children, the object-level operation order is delete parent, then delete children. In my experience, the cascade should delete the children first. This solves 99% of the cascade delete issues. Craig On Sep 11,