@Id
@SequenceGenerator(name = "SEQ_表_字段_ID", sequenceName = "SEQ_表_字段_ID")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_表_字段_ID")
@Column(name = "ID", unique = true, nullable = false, insertable = true, updatable = false, length = 22)
public Long getId() {
return id;
}
//2019/2/18记
在自测过程中,发现插入的数据中,id有负数的情况。如下:
跟dba讨论了下,查看创建数据库表序列是否有问题。以下为创建的序列sql
/*创建该表序列*/
CREATE SEQUENCE SEQ_表_字段_ID
INCREMENT BY 1
START WITH 1
MINVALUE 1
MAXVALUE 1E28
NOCYCLE
CACHE 20;
sql没问题,按照现有的规范去配置,开始值为1。
后面发现是id策略配置的问题。以下为修改后的id配置:
@Id
@SequenceGenerator(name = "SEQ_表_字段_ID", sequenceName = "SEQ_表_字段_ID", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_表_字段_ID")
@Column(name = "ID", unique = true, nullable = false, insertable = true, updatable = false, length = 22)
public Long getId() {
return id;
}
重点配置在于:allocationSize = 1
参考的链接: