While upgrading from hibernate 3 to hibernate 5, this was one of the issues.
Here is how id fields were defined in hibernate 3.
@Id
@GeneratedValue(strategy=GenerationType.AUTO, generator="my_seq_gen")
@SequenceGenerator(name="my_seq_gen", sequenceName="MY_SEQ")
private long id;
So now, I added allocationSize = 1
to resolve the issue
@Id
@GeneratedValue(strategy=GenerationType.AUTO, generator="my_seq_gen")
@SequenceGenerator(name="my_seq_gen", sequenceName="MY_SEQ", allocationSize = 1)
private long id;
And for new Ids I used the below declaration
@GenericGenerator(
name = "MySequenceGenerator",
strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator",
parameters = {
@Parameter(name = "sequence_name", value = "MySequence"),
@Parameter(name = "initial_value", value = "1"),
@Parameter(name = "increment_size", value = "1")
}
)
@GeneratedValue(generator = "MySequenceGenerator")
@Id
private Long id = null;