Foreign key not stored in child entity (one-to-many)
Posted
by Kamil Los
on Stack Overflow
See other posts from Stack Overflow
or by Kamil Los
Published on 2010-03-26T07:24:36Z
Indexed on
2010/03/26
7:33 UTC
Read the original article
Hit count: 256
Hi, I'm quite new to hibernate and have stumbled on this problem, which I can't find solution for.
When persisting parent object (with one-to-many relationship with child), the foreign-key to this parent is not stored in child's table.
My classes:
Parent.java
@javax.persistence.Table(name = "PARENT")
@Entity
public class PARENT {
private Integer id;
@javax.persistence.Column(name = "ID")
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
private Collection<Child> children;
@OneToMany(mappedBy = "parent", fetch = FetchType.EAGER, cascade = {CascadeType.ALL})
@Cascade({org.hibernate.annotations.CascadeType.ALL})
public Collection<Child> getChildren() {
return children;
}
public void setChildren(Collection<Child> children) {
this.children = children;
}
}
Child.java
@javax.persistence.Table(name = "CHILD")
@Entity
@IdClass(Child.ChildId.class)
public class Child {
private String childId1;
@Id
public String getChildId1() {
return childId1;
}
public void setChildId1(String childId1) {
this.childId1 = childId1;
}
private String childId2;
@Id
public String getChildId2() {
return childId2;
}
public void setChildId2(String childId2) {
this.childId2 = childId2;
}
private Parent parent;
@ManyToOne
@javax.persistence.JoinColumn(name = "PARENT_ID", referencedColumnName = "ID")
public Parent getParent() {
return parent;
}
public void setParent(Operation parent) {
this.parent = parent;
}
public static class ChildId implements Serializable {
private String childId1;
@javax.persistence.Column(name = "CHILD_ID1")
public String getChildId1() {
return childId1;
}
public void setChildId1(String childId1) {
this.childId1 = childId1;
}
private String childId2;
@javax.persistence.Column(name = "CHIILD_ID2")
public String getChildId2() {
return childId2;
}
public void setChildId2(String childId2) {
this.childId2 = childId2;
}
public ChildId() {
}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
ChildId that = (ChildId) o;
if (childId1 != null ? !childId1.equals(that.childId1) : that.childId1 != null)
return false;
if (childId2 != null ? !childId2.equals(that.childId2) : that.childId2 != null)
return false;
return true;
}
@Override
public int hashCode() {
int result = childId1 != null ? childId1.hashCode() : 0;
result = 31 * result + (childId2 != null ? childId2.hashCode() : 0);
return result;
}
}
}
Test.java
public class Test() {
private ParentDao parentDao;
public void setParentDao(ParentDao parentDao) {
this.parentDao = parentDao;
}
private ChildDao childDao;
public void setChildDao(ChildDao childDao) {
this.childDao = parentDao;
}
test1() {
Parent parent = new Parent();
Child child = new Child();
child.setChildId1("a");
child.setChildId2("b");
ArrayList<Child> children = new ArrayList<Child>();
children.add(child);
parent.setChildren(children);
parent.setValue("value");
parentDao.save(parent); //calls hibernate's currentSession.saveOrUpdate(entity)
}
test2() {
Parent parent = new Parent();
parent.setValue("value");
parentDao.save(parent); //calls hibernate's currentSession.saveOrUpdate(entity)
Child child = new Child();
child.setChildId1("a");
child.setChildId2("b");
child.setParent(parent);
childDao.save(); //calls hibernate's currentSession.saveOrUpdate(entity)
}
}
When calling test1(), both entities get written to database, but field PARENT_ID in CHILD table stays empty.
The only workaround I have so far is test2() - persisting parent first, and then the child.
My goal is to persist parent and its children in one call to save() on Parent. Any ideas?
© Stack Overflow or respective owner