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

Integrity constraint violated while cascade merging entity with @ManyToOne relationship

    XMLWordPrintableJSON

Details

    • 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 12.1.0.2.0
      Environments: JavaSE and JavaEE (TomEE 1.7.4)
      JDBC driver version: ojdbc6, ojdbc7(12.1.0.2), ojdbc8

    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.

      Attachments

        1. failcase.zip
          5 kB
          Riccardo Ambrosio

        Activity

          People

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

            Dates

              Created:
              Updated: