Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2708

Integrity constraint violated while cascade merging entity with @ManyToOne relationship



    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.4.0, 2.4.1, 2.4.2
    • None
    • jpa, kernel
    • OS: CentOS/RHEL, Archlinux, Ubuntu
      RDBMS: Oracle Database 12c Standard Edition Release
      Environments: JavaSE and JavaEE (TomEE 1.7.4)
      JDBC driver version: ojdbc6, ojdbc7(, ojdbc8


      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.


        1. failcase.zip
          5 kB
          Riccardo Ambrosio



            Unassigned Unassigned
            kalelkenobi Riccardo Ambrosio
            0 Vote for this issue
            2 Start watching this issue