[OPENJPA-431] Order INSERT statements on joined subclasses from parent to child

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.0.0
• Component/s: sql
• Assignee: Unassigned
• Reporter: Nick Johnson
• Created: 04/Nov/07 01:56
• Updated: 06/Nov/07 19:04
• Resolved: 06/Nov/07 06:41

Description

When creating a joined subclass relationship, it is desirable on the database side to place an integrity constraint on the subclass table that its object_id must exist in the parent class's table. (Because the subclass's row cannot exist without the parent class's row.)

Unfortunately, OpenJPA orders the inserts in the opposite direction, trying to insert the child entity first (probably because that's the entity that the code is actually persisting), so with the integrity constraint in place, the insert will fail.

It would be nice if in a joined-subclass relationship where multiple inserts were needed, SQL would be issued in order of highest in the class hierarchy to lowest so that integrity constraints on the database won't be violated.

Issue Links

• relates to: OPENJPA-435 Change mapping defaults to assume foreign keys exist for relationships by default