数据库持久期间的hibernate嵌套异常

Question

在插入记录数据库过程中，我正在与以下问题作斗争。

2018-08-12 16:06:26.874警告5482---[nio-8080-exec-2]O.H.Engine.jdbc.spi.sqlexceptionHelper：SQL错误：1364,SQLState：HY000 2018-08-12 16:06:26.875错误5482--[nio-8080-exec-2]O.H.Engine.jdbc.spi.sqlexceptionHelper：字段“country_id”没有默认值查询是：插入bi_person(additional_info,gender_id,last_name,name）值（？,？,？,？）,参数['Java嵌套异常为org.springframework.orm.jpa.jpasystemexception：无法执行语句；html" target="_blank">嵌套异常为org.hibernate.exception.GenericJDBCException：could not execute statement]（根本原因

查询异常：字段“country_id”没有默认值查询为：insert INTERBI_PERSON(additional_info,gender_id,last_name,name）值（？,？,？,？）,参数['Java Master',48,'ww','john']*

//Coutry：

@Table(name = "bi_country")
@Entity
public class Country {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id_country")
    private Integer id;

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

    @ManyToMany(cascade = CascadeType.ALL)
    @JoinTable(name="country_book", joinColumns=@JoinColumn(name="id_country"), inverseJoinColumns=@JoinColumn(name="id_person"))
    private Set<Person> persons;

//性别：

@Table(name = "bi_gender")
@Entity
public class Gender {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id_gender")
    private Integer id;

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

//人

@Table(name = "bi_person")
@Entity
public class Person {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id_person")
    private Integer id;

    @Column(name = "name")
    private String name;
    @Column(name = "last_name")
    private String lastName;
    @Column(name = "additional_info")
    private String additionalInfo;


    @ManyToOne
    private Gender gender;

    @ManyToMany(cascade=CascadeType.ALL)
    private Set<Country> countries;

Answer 1

您只需仔细阅读错误消息即可。上面写着：

字段“country_id”没有默认值查询为：insert into bi_person（additional_info,gender_id,last_name,name)...

因此，您的bi_person表有一个名为country_id的字段，它没有任何默认值。当然，Hibernate不会在该字段中插入任何内容，因为它在实体Person中没有任何这样的字段。所以你得到了这个例外。