Hibernate@joincolumns，可插入 true 不允许插入

Question

我有两个表，它们的关系如下图所示

我创建了Hibernate数据模型，如下所示

@Entity
@Table(name = "SUBJECT")
public class Subject {

  @Column(name = "NAME")
  private String name;

  @Column(name = "ADDRESS")
  private String address;

  @Column(name = "CLIENT_ID")
  private String clientId;

  @OneToMany(mappedBy = "subject", fetch = FetchType.LAZY, cascade = CascadeType.ALL)
  private List<SSI> SSIs;

  // getters and setters
  ...
  
}

@Entity
@Table(name = "SUBJECT_IDENTIFIER")
public class SubjectIdentifier {

  @Column(name = "VALUE")
  private String value;


  @Column(name = "AUTHORITY")
  private String authority;


  @Column(name = "TYPE")
  private String type;


  @ManyToOne
  @JoinColumns({
      @JoinColumn(name = "SUBJECT_ID", referencedColumnName = "ID", insertable = true,
          updatable = true,
      @JoinColumn(name = "CLIENT_ID", referencedColumnName = "CLIENT_ID", insertable =
          true, updatable = true)
  })
  private Subject subject;

  // getters and setters
  ...
}

@Entity
@Table(name = "SSI")
public class SSI {
  @ManyToOne
  @JoinColumns({
      @JoinColumn(name = "SUBJECT_ID", referencedColumnName = "ID", insertable = true,
          updatable = true),
      @JoinColumn(name = "CLIENT_ID", referencedColumnName = "CLIENT_ID", insertable =
          true, updatable = true)
  })
  private Subject subject;

  @OneToOne(cascade = CascadeType.ALL)
  @JoinColumns({
      @JoinColumn(name = "SUBJECT_IDENTIFIER_ID", referencedColumnName = "ID", insertable = true,
          updatable = true),
      @JoinColumn(name = "CLIENT_ID", referencedColumnName = "CLIENT_ID", insertable =
          true, updatable = true)
  })
  private SubjectIdentifier subjectIdentifier;

  // getters and setters
  ...
}

我打算创建如下实体

  ...
  Subject s = new Subject();
  //.. initialization of s goes here

  SubjectIdentifier si = new SubjectIdentifier();
  //.. initialization of si goes here

  SSI ssi = new SSI();
  ssi.setSubject(s);
  ssi.setSubjectIdentifier(si);

  s.setSSI(ssi);

  ...
  emProvider.get().persist(s); 

当我运行这个时，我得到以下错误

org.hibernate.MappingException：实体映射中的重复列：*。SSI 列：CLIENT_ID（应使用 insert=“false” update=“false”进行映射）

如果我设置插入="false"更新="false"为CLIENT_ID，它将再次错误关于插入的混合

如果我为所有@JoinColumns设置insert=“false”update=“false”，那么它不会保留对象。

如何真正处理这种实体创建？

Answer 1

您可以访问下面的链接:

org.hibernate.MappingException:实体映射中的列重复