>我正在尝试使用数据库表"persons"实现单个表休眠继承策略。
我有一个家庭,里面有一个丈夫,一个妻子,一个孩子和其他囚犯的名单。每个人都可以是许多家庭的成员(即丈夫可能是一个家庭的丈夫,另一个家庭的孩子)。
@Entity
@Table(name = "families")
public class Family extends BaseObject {
private Parent husband;
private Parent wife;
private String surname;
private List<Child> children = new ArrayList<Child>();
private List<Other> others = new ArrayList<Other>();
@ManyToOne(optional = true, cascade = CascadeType.ALL)
@JoinColumn(name = "husband_id", nullable = true)
public Parent getHusband() {
return husband;
}
@ManyToOne(optional = true, cascade = CascadeType.ALL)
@JoinColumn(name = "wife_id", nullable = true)
public Parent getWife() {
return wife;
}
@LazyCollection(LazyCollectionOption.TRUE)
@ManyToMany(cascade=CascadeType.ALL)
@JoinTable(name="persons_families", joinColumns=@JoinColumn(name="family_id"), inverseJoinColumns=@JoinColumn(name="person_id"))
public List<Other> getOthers() {
return others;
}
@LazyCollection(LazyCollectionOption.TRUE)
@ManyToMany(cascade=CascadeType.ALL)
@JoinTable(name="persons_families", joinColumns=@JoinColumn(name="family_id"), inverseJoinColumns=@JoinColumn(name="person_id"))
public List<Child> getChildren() {
return children;
}
人是所有人的共同类别:
@Entity
@Table(name = "persons")
@DiscriminatorColumn(name = "type")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
public class Person extends BaseObject {
private List<Family> families;
@ManyToMany(cascade=CascadeType.ALL)
@ManyToMany(cascade=CascadeType.ALL)
@JoinTable(name="persons_families", joinColumns=@JoinColumn(name="person_id"), inverseJoinColumns=@JoinColumn(name="family_id"))
public List<Family> getFamilies() {
return families;
}
子类、其他类和父类是相同的:
@Entity
@Table(name = "persons")
@DiscriminatorValue(value = "children")
public class Child extends Person {}
@Entity
@Table(name = "persons")
@DiscriminatorValue(value = "others")
public class Other extends Person {}
@Entity
@Table(name = "persons")
@DiscriminatorValue(value = "parents")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
public class Parent extends Person {}
现在在系统启动期间我有以下问题:
org.hibernate.MappingException: Repeated column in mapping for entity: org.parafia.model.Other column: type (should be mapped with insert="false" update="false")
我能做些什么呢?我的模型有意义吗?
此致敬意
我的模型有意义吗?
它不是:如果你的目标是,比如说,爱丽丝是某个家庭的母亲,也是另一个家庭的孩子,那么爱丽丝在persons
行的type
应该是什么?爱丽丝应该是Parent
还是Child
的实例?
子类必须是析取集。