[OPENJPA-2708] Integrity constraint violated while cascade merging entity with @ManyToOne relationship

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4.0, 2.4.1, 2.4.2
• Component/s: jpa, kernel
• Labels: cascade manytoone merge oracle
• Environment: OS: CentOS/RHEL, Archlinux, Ubuntu; RDBMS: Oracle Database 12c Standard Edition Release 12.1.0.2.0; Environments: JavaSE and JavaEE (TomEE 1.7.4); JDBC driver version: ojdbc6, ojdbc7(12.1.0.2), ojdbc8
• Assignee: Unassigned
• Reporter: Riccardo Ambrosio
• Created: 26/Jul/17 10:02
• Updated: 01/Aug/20 07:28

Description

When trying to merge an Entity which has a ManyToOne relationship annotated as follows:

@ManyToOne(cascade =

{CascadeType.PERSIST, CascadeType.MERGE, CascadeType.REFRESH, CascadeType.DETACH}

, fetch = FetchType.EAGER)

I get an ORA-02291: integrity constraint violated - parent key not found. It looks like OpenJPA is trying to insert the parent entity before inserting the children. This only happens to me when using an Oracle Database and when the children are new entities (the update works fine). I've reproduced the issue in a simple testcase (see attachment) using open-jpa-all jar in a JavaSE environment, but I've also tested it using TomEE in a JavaEE environment.

I'm still a little skeptical that such an issue could have gone unnoticed for such a long time, so I'm pretty sure I am doing something wrong here. If that's the case please forgive me for opening this issue, but I'm out of ideas and this is causing me some serious head ache.