问题描述
我不知道如何设置@GenerateValue
@Id
的初始值.
I can not figure out how to set the initial value for the @GenerateValue
@Id
.
我尝试使用GenerationType.SEQUENCE
,但是在MySQL
中不允许这样做.如何设置用于@GenerateValue
的初始值?
I have tried using GenerationType.SEQUENCE
but that is not allowed in MySQL
. How can I set the initial value to be used for the @GenerateValue
?
同时使用AUTO
和TABLE
,我仍然无法获得除1
Using both AUTO
and TABLE
I can still not get the initial value to start at anything but 1
谢谢
代码,使用自动
@Entity
@Data
@SequenceGenerator(name = "port_gen", sequenceName = "port_gen", initialValue = 4700)
public class AppiumPort {
@Id
@GeneratedValue(strategy = GenerationType.AUTO, generator = "port_gen")
private Long port;
public AppiumPort() {
}
}
使用TABLE的代码
@Entity
@Data
public class AppiumPort {
@TableGenerator(name = "Address_Gen", table = "ID_GEN", pkColumnName = "GEN_NAME", valueColumnName = "GEN_VAL", pkColumnValue = "Addr_Gen", initialValue = 10000, allocationSize = 100)
@Id
@GeneratedValue(strategy = GenerationType.TABLE, generator = "Address_Gen")
private int port;
public AppiumPort() {
}
}
**更新**
问题与未设置hibernate.id.new_generator_mappings = true;
The problem was related to not setting hibernate.id.new_generator_mappings=true;
https://docs.jboss.org/hibernate/stable/annotations/reference/zh-CN/html/ch01.html
用于Sring Boot的Application.properties:
Application.properties for Sring Boot:
spring.jpa.properties.hibernate.id.new_generator_mappings=true
推荐答案
您可以尝试使用@TableGenerator(JPA具有@TableGenerator批注,您可以在其中设置初始值). initialValue可以用来播种值
You could try and use the @TableGenerator (JPA has a @TableGenerator annotation in which you can set an initial value). The initialValue can be used to seed the values
此处为示例: http://www.java2s.com/Code/Java /JPA/SetInitialValueOfTableGenerator.htm
这篇关于如何在Spring JPA for MySQL中为@Id @GeneratedValue设置初始值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!