java - hibernate ConstraintViolationException : could not delete the SortedSet Collection of Child

Question

我有以下两个类:Claim(父级)和 ClaimInsurance(子级)。它们如下:

public class Claim {    
  private SortedSet<ClaimInsurance> claimInsurances = new TreeSet<ClaimInsurance>();

  @OneToMany(cascade=CascadeType.ALL, fetch=FetchType.LAZY, mappedBy="claim", orphanRemoval=true)
  @Sort(type=SortType.NATURAL)
  public SortedSet<ClaimInsurance> getClaimInsurances() {
    return this.claimInsurances;
  }

  public void setClaimInsurances(SortedSet<ClaimInsurance> claimInsurances) {
    this.claimInsurances = claimInsurances;
  }
}

和:

public class ClaimInsurance implements java.io.Serializable, Comparable<ClaimInsurance> {
  private Claim claim;

  @ManyToOne(fetch=FetchType.LAZY)
  @JoinColumn(name="ClaimId", nullable=false)
  public Claim getClaim() {
    return this.claim;
  }

  public void setClaim(Claim claim) {
    this.claim = claim;
  }
}

当我尝试删除 Claim 时，它给出了以下异常

org.hibernate.exception.ConstraintViolationException: could not delete: [com.omnimd.pms.beans.Claim#201]
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "FK_RCMSClaimInsuranceTable_RCMSClaimTable". The conflict occurred in database "Omnimdv12", table "dbo.RCMSClaimInsuranceTable", column 'ClaimId'.

当我如下更改 Claim 类中的 claimInsurances 映射时，一切正常:

private Set<ClaimInsurance> claimInsurances = new HashSet<ClaimInsurance>();

@OneToMany(cascade=CascadeType.ALL, fetch=FetchType.LAZY, mappedBy="claim", orphanRemoval=true)
public Set<ClaimInsurance> getClaimInsurances() {
  return this.claimInsurances;
}

public void setClaimInsurances(Set<ClaimInsurance> claimInsurances) {
  this.claimInsurances = claimInsurances;
}

问题似乎是当我在映射中使用 Set (HashSet) 时它起作用了，但是如果我改为使用 SortedSet ( TreeSet) 它给出一个错误。

实际问题可能是什么？我错过了什么？

Answer 1

好的。现在问题已经解决了。在@JB Nizet 的帮助下

对于相同的 Claim，我有多个 ClaimInsurance，其 compareTo() 给出相同的结果。

我更改了 ClaimInsurance 中的 compareTo()，这样它将为相同的 Claim 返回不同的值..就是这样，它现在可以工作了.