Spring数据JPA-手动插入后键冲突

Question

我有一个使用Spring Boot/hibernate的简单项目，在单元测试中插入新值时有bug。对于测试，我使用了一个带有虚拟数据（data.sql）的新数据库，在启动后，当插入测试运行时，我出现了一个错误“密钥冲突”：

2019-01-15 10:14:00,286 ERROR [main] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.NATURAL_PERSON_CATEGORY(ID)"; SQL statement:
insert into natural_person_category (created_by, creation_date, deletion_by, deletion_date, modification_date, modificationd_by, comment, label, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-194]

我管理带有注释的ID:@ID@GeneratedValue（策略=GenerationType.Auto)

@Data
@Entity
@Table
public class NaturalPerson {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @JsonProperty("id_natural_person")
    protected Integer id;

    @JsonProperty("first_name")
    private String firstName;

    @JsonProperty("last_name")
    private String lastName;

    @JsonProperty("is_minor")
    private boolean isMinor;

    private String mail;

    @OneToMany(cascade = CascadeType.ALL)
    private List<Address> addresses;


    @OneToOne(cascade = CascadeType.ALL)
    @JsonProperty("category")
    private NaturalPersonCategory naturalPersonCategory;

    @JsonProperty("is_main")
    private boolean isMain;


    @JsonGetter("fullname")
    public String getFullname() {
        return this.firstName + " " + this.lastName;
    }

}

@data@entity@table公共类地址{

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @JsonProperty("id_address")
    protected Integer id;

    private String line1;
    private String line2;
    private String line3;

    @JsonProperty("postal_code")
    private String postalCode;

    private String city;

    @ManyToOne
    @JoinColumn(name = "id_country")
    private Country country;

    @JsonProperty("start_date")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date startDate;

    @JsonProperty("end_date")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date endDate;
}

@Data
@Entity
@Table
public class NaturalPersonCategory {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @JsonProperty("id_natural_person_category")
    protected Integer id;

    @NotNull
    protected String label;

    @Column(columnDefinition = "TEXT")
    protected String comment;

}

Answer 1

我已经解决了这个问题

@GeneratedValue(strategy = GenerationType.IDENTITY)