[jira] [Created] (OPENJPA-2604) How to persist multi level associations

[Nimisha Gupta (JIRA)]

Nimisha Gupta created OPENJPA-2604:
--------------------------------------

             Summary: How to persist multi level associations
                 Key: OPENJPA-2604
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2604
             Project: OpenJPA
          Issue Type: Question
    Affects Versions: 1.1.0
            Reporter: Nimisha Gupta


I am trying to persist a three level association 
(i.e.Grandparent->Parents->Children)

A grandparent can have multiple parents and each parent can have multiple 
children.

I am trying to leverage the CASCADE option but am failing to do so.

Though I am able to persist in a two level association (i.e. Parent-> Children).

Could you please guide me as to what am I doing wrong in my entities?

GrandParent.java
--------------------------
@Column(name="O_ID")
private int oID;

@OneToMany(mappedBy = "grandparent", cascade = CascadeType.ALL, fetch = 
FetchType.EAGER, targetEntity = Parent.class)
        private Set<Parent> parents;

Parent.java
-------------
        @ManyToOne
        @JoinColumn(name = "O_ID", insertable = false, updatable = false)
        private Grandparent grandparent;

        @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL, mappedBy 
= "parent", targetEntity = Child.class)
        private Set<Child> children;

Child.java
-------------
@ManyToOne
        @JoinColumns({ @JoinColumn(name = "O_ID", referencedColumnName = 
"O_ID", insertable = false, updatable = false),
                        @JoinColumn(name = "PRNT_ID", referencedColumnName = 
"PRNT_ID", insertable = false, updatable = false) })
        private Parent parent;

Grandparent table-> PK- {O_ID}
Parent table-> PK-{O_ID, PRNT_ID}
Child table-> PK-{O_ID, PRNT_ID, CHILD_ID}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)