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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

JIRA jira@apache.org
Riccardo Ambrosio created OPENJPA-2708:
------------------------------------------

             Summary: Integrity constraint violated while cascade merging entity with @ManyToOne relationship
                 Key: OPENJPA-2708
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2708
             Project: OpenJPA
          Issue Type: Bug
          Components: jpa, kernel
    Affects Versions: 2.4.2, 2.4.1, 2.4.0
         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
            Reporter: Riccardo Ambrosio
         Attachments: failcase.zip

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.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
Loading...