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

["Nimisha Gupta (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-2604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14680173#comment-14680173 ] 

Nimisha Gupta commented on OPENJPA-2604:
----------------------------------------

Please also let me know incase this scenario can be achieved by jpa or not?





> 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)