错误：“XX”列中的空值违反非空约束SPRING

Question

我有亲子关系。当我时。save要在标识符相同时插入，我希望它更新。

这是我的服务：

@Override
public MsExplodedDTO saveExplodedFactory(MsExplodedFactoryRequestDTO exploded) {
    
    MsProduct prod = msProductRepo.findByProductCode(exploded.getProductCode())
            .orElseThrow(() -> new ResourceNotFound("Data Produk tidak ditemukan!"));

    
    exploded.setProductCode(prod.getId().toString());
    
    MsExploded exp;
    if (explodedRepo.findByExplodedCodeIgnoreCase(exploded.getExplodedCode()).size() > 0) {
        
        MsExploded oldExploded = explodedRepo.findByExplodedCode(exploded.getExplodedCode())
                .orElseThrow(() -> new ResourceNotFound("Data tidak ditemukan!"));
        
        return updateExplodedFactory(exploded, prod);
    }else {
        exp = mapper.DTO2Entity(exploded);
        exp.setId(0L);
        exp.getExplodedDt().forEach(d -> {
            d.setExplodedhd(exp);
        });
        
        return mapper.entity2DTO(explodedRepo.save(exp));
    }
    
}

@Override
public MsExplodedDTO updateExplodedFactory(MsExplodedFactoryRequestDTO exploded, MsProduct prod) {

    MsExploded oldExploded = explodedRepo.findByExplodedCode(exploded.getExplodedCode())
            .orElseThrow(() -> new ResourceNotFound("Data tidak ditemukan!"));

    if (oldExploded.getIsDeleted()) {
        throw new ResourceNotAcceptable("Kode Exploded " + oldExploded.getExplodedCode() + " telah dihapus");
    }

    oldExploded = mapper.updateDTO2Entity(exploded, oldExploded);
    oldExploded.setProduct(prod);
    

    for (MsExplodedDetail exp : oldExploded.getExplodedDt()) {
        exp.setExplodedhd(oldExploded);
    }

    MsExploded obj = explodedRepo.save(oldExploded);

    return mapper.entity2DTO(obj);
}

当我调试更新时，它说

错误：“ms\u exploded\u header\u id”列中的null值违反非null约束详细信息：失败行包含（20，333，2，null，null，null，null，null，null，null，null，null）。

虽然我已经按应有的方式插入了存储库，但在保存新存储库时没有问题，但在更新父或子存储库时却没有问题。

这是我的标题实体：

@Data
@Audited
@EntityListeners(AuditingEntityListener.class)
@Entity
@Table(name = "ms_exploded")
@EqualsAndHashCode(callSuper = false, of = "id")
@ToString(of = { "id" })
public class MsExploded extends AuditField implements Serializable {
XX
XX
XX
@OneToMany(mappedBy = "explodedhd", orphanRemoval = true, cascade = CascadeType.ALL)
    private List<MsExplodedDetail> explodedDt = new ArrayList<>();
}

这是我的孩子实体：

@Data
@Audited
@EntityListeners(AuditingEntityListener.class)
@Entity
@Table(name = "ms_exploded_detail")
public class MsExplodedDetail implements Serializable {
XX
XX
XX
@JsonIgnoreProperties({ "hibernateLazyInitializer", "handler" })
    @JsonIgnore
    @ManyToOne(targetEntity = MsExploded.class)
    @JoinColumn(name = "ms_exploded_header_id", referencedColumnName = "id")
    private MsExploded explodedhd;
}

我很确定在调试时，ms\u exploded\u header\u id与头id一起插入。但我不知道为什么它取消并返回了错误。

Answer 1

确保msexplod。explodedDt和msexplodeDetail。explodedhd始终一致。一、 e.以下断言应成立：

msExploded.explodedDt.forEach(dt -> assertThat(dt.explodedhd).isEqualTo(msExploded);

assertthat(msExplodedDetail.explodedhd).contains(msExplodedDetail)

我怀疑你（或地图绘制者）离开了MsExplodedDetail。在向MSExplod添加细节时，分解DHD。