Spring boot删除不是级联的，它是将外键设置为null，然后在空约束上失败

Question

在Spring Boot中使用deleteById与一对多关系生成的查询尝试将引用实体中的外键设置为null，而不是删除它们。我正在使用默认存储库deleteById

我已在实体中的外键定义中将 Cascadetype 设置为 ALL，将 OrpahnRemoval 设置为 true，并在创建表的 DDL 中设置 ON DELETE CASCADE。

这里是controller类中的删除操作

@Transactional

@DeleteMapping("transferImage/{imageId}")

public void  deleteTransferImage(@PathVariable int imageId) {

    repository.deleteById(imageId);

}

这是从父实体到子实体的引用

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, OrphanRemoval = true)

@JoinColumn(name = "TRANSFER_IMAGE_ID")

private List<TransferPartition> partitions = new ArrayList<>();

这是子实体中外键的定义

@JsonIgnore

@ManyToOne

@JoinColumn(name = "TRANSFER_IMAGE_ID", referencedColumnName = "TRANSFER_IMAGE_ID")

private TransferImage image;

这是用于创建两个表的 DDL

CREATE TABLE TRANSFER_IMAGE (

TRANSFER_IMAGE_ID       SERIAL CONSTRAINT TRANSFER_IMAGE_PK PRIMARY KEY,

IMAGE_NAME              VARCHAR(50) CONSTRAINT TRANSFER_IMAGE_NAME_UK UNIQUE NOT NULL ,

REQUESTED_PART_SIZE_MB  INTEGER NOT NULL,

SIZE_BYTES              INTEGER NOT NULL,

IMAGE_MD5_HASH          VARCHAR(100),

NUMBER_PARTITIONS       INTEGER,

DELETED                 BOOLEAN  NOT NULL

);

CREATE TABLE TRANSFER_PARTITION (

TRANSFER_PARTITION_ID   SERIAL CONSTRAINT TRANSFER_PARTITION_PK PRIMARY KEY,

TRANSFER_IMAGE_ID       INTEGER NOT NULL CONSTRAINT TRANSFER_PARTITION_IMAGE_FK REFERENCES TRANSFER_IMAGE ON DELETE CASCADE ON UPDATE CASCADE,

PARTITION_NUMBER        INTEGER NOT NULL,

PARTITION_MD5_HASH      VARCHAR(100) NOT NULL,

SIZE_BYTES              INTEGER NOT NULL

);

Answer 1

您的问题在于 TransferImage 类中外键关系的定义。代替@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, OrphanRemoval = true)@JoinColumn(name = "TRANSFER_IMAGE_ID")private List<TransferPartition> partitions = new ArrayList<>();你应该使用@OneToMany(mappedBy="image", cascade = CascadeType.ALL, fetch = FetchType.EAGER, OrphanRemoval = true)private List<TransferPartition> partitions = new ArrayList<>();