"org.springframework.dao.数据完整性违反异常：无法执行语句

Question

这是列表类

@Entity
@Table(name = "list")
public class List extends AbstractEntity {

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

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

    @Column(name = "date")
    @JsonFormat(pattern = "yyyy-MM-dd'T'HH:mm:ss")
    private Date date;

    //getters and setters
}

下面是执行类

@Entity
@Table(name = "EXECUTION")
public class Execution extends AbstractEntity {

    @ManyToOne(targetEntity = List.class)
    @JoinColumn(name = "list_id")
    private List list;

    @Column(name = "date")
    @NotNull
    @JsonFormat(pattern = "yyyy-MM-dd'T'HH:mm:ss")
    private Date date;
}

以下是控制器删除列表的方法

@RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
@ResponseStatus(HttpStatus.NO_CONTENT)
public void deleteList(@PathVariable("id") Long listId) {
    List list = listRepository.findOne(listId);

    listRepository.delete(listId);
}

当我执行上述代码时，我得到以下错误

: ERROR: update or delete on table "list" violates foreign key constraint "fkmnja1nmiq9v42f0ojydccxf20" on table "execution"

详细信息：键（id）=（1）仍然从表“执行”中引用。

在删除具有特定id的列表表之前，如何删除具有列表id的执行表？

任何帮助都将不胜感激。非常感谢。

Answer 1

定义关系中的级联行为，

@Entity
@Table(name = "EXECUTION")
public class Execution extends AbstractEntity {
    //add cascade , so on delete of list all the execution will also be removed
    @ManyToOne(targetEntity = List.class, cascade = {CascadeType.ALL})
    @JoinColumn(name = "list_id")
    private List list;

    @Column(name = "date")
    @NotNull
    @JsonFormat(pattern = "yyyy-MM-dd'T'HH:mm:ss")
    private Date date;
}