could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.excepti

原创于 2019-07-03 11:02:20 发布 · 2.7w 阅读

1 ·

CC 4.0 BY-SA版权

Error 专栏收录该内容

1 篇文章

订阅专栏

本文解析了Spring框架中DataIntegrityViolationException异常的原因，通常由实体类的必填属性id为空触发。深入探讨了两个实体类Systemdictionarydetailext和Systemdictionarytype的配置，以及如何通过设置id值或改进下拉框选择来解决这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错内容

org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

俩个实体类

@Entity
@Table(name="systemdictionarydetail")
@JsonIgnoreProperties( value={"hibernateLazyInitializer","handler"})
public class Systemdictionarydetail extends Base{
    private String name;
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="types_id")
    private Systemdictionarytype types;

@Entity
@Table(name="systemdictionarytype")
@JsonIgnoreProperties( value={"hibernateLazyInitializer","handler"})
public class Systemdictionarytype extends Base{
    public static final String PRODUCT_BRAND="productBrand";
    public static final String PRODUCT_UNIT="productUnit";

    private String name;

    @Column(updatable = false)
    private String sn;