在JPA工程中使用注解添加唯一索引:
@Entity
@Table(name = "DAAM_PUBLICDATACOLUMN",
uniqueConstraints = {
@UniqueConstraint(name = "uk_code",columnNames = {"code"}),
@UniqueConstraint(name = "uk_caption", columnNames = {"caption"})},
indexes = {
@Index(name = "uk_parentId", columnList = "parentId")})
public class PublicDataColumnEntity {
结果数据库中只存在一个uk_code的唯一键
Hibernate: alter table DAAM_PUBLICDATACOLUMN drop constraint uk_caption
Hibernate: alter table DAAM_PUBLICDATACOLUMN add constraint uk_caption unique (CAPTION)
手工执行hibernate打印的sql语句: