无法删除或更新父行一对多Hibernate

Question

当我试图删除宠物时，我得到了这个错误。这个宠物，有访问（子），但我在宠物实体中定义了CASCADE. ALL。任何想法？错误：无法删除或更新父行：外键约束失败（web_customer_tracker。

 @Entity
@Table(name = "pets")
public class Pet {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "pet_id")
    private int pet_id;

    .....

    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "visit_id")
    private Set<Visit> visits;

访问类：

@Entity
@Table(name = "visits")
public class Visit {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "visit_id")
    private int visit_id;

    @ManyToOne
    @JoinColumn(name = "pet_id")
    private Pet pet;

    ....

Answer 1

您使用mappedBy的方式不正确mappedBy引用了另一侧的对象名称

就像这样

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "pet")
private Set<Visit> visits;

或者，如果您想通过joincolm映射它，请尝试以下操作

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name = "pet_id")
private Set<Visit> visits;