Hibernate @SequenceGenerator return incorrect value in MS SQL

Question

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "generator")
@SequenceGenerator(name = "generator", schema = "MD", sequenceName = "sq_base_class")
public Long getId() {
    return id;
}

Hi! I have entity which using MS SQL Sequence for generating ID, but value is incorrect.

com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK_BCL'. Cannot insert duplicate key in object 'MD.BASE_CLASS'. The duplicate key value is (551009).

Example: SequenceGenerator set ID = 551009, but select next value for md.sq_base_class return 551115. How to resolve it? Hibernate-version: 5.3.10.Final

Roman Yushchenko · Accepted Answer · 2020-05-20 06:24:04Z

1

Maybe you lost the allocation size = 1 in @SequenceGenerator

answered May 20, 2020 at 6:24

Roman Yushchenko

544 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate @SequenceGenerator return incorrect value in MS SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related