Spring JPA处理唯一约束违反[重复]

Question

我有一个实体，比如说雇员

@Entity
public class Employee {
    @Id
    private Long id;
    private String name;
    ....
}

with字段名标记为唯一。

org.springframework.dao.DataIntegrityViolationException: could not execute batch; 
SQL......at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccess
Exception(HibernateJpaDialect.java:298)......
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch......
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (SILKGATE_TEST.SYS_C00100705) violated.....

提前谢谢你

Answer 1

可以使用unique=true。

@Entity
public class Employee {
    @Id
    private Long id;

    @Column(nullable = false, unique = true)
    private String name;
    ....
}