CODEWITHSUNDEEP
jpasequence
Adolis Pali
Adolis Pali

Reputation: 339

PostgresSQL JPA custom sequence

  1. in postgres I create sequence: user_details_userid_seq
  2. now I want to use it in my class
public class UserDetails {
    @Id
    private int userId;

I want what userId would read and generate next value of user_details_userid_seq (which is defined in databas). How to do this?

Upvotes: 0

Views: 43

Answers (1)

Adolis Pali
Adolis Pali

Reputation: 339

Thanks crizzis for keywords to search, but solution:

@GeneratedValue(generator="my_seq_gen")
@SequenceGenerator(name="my_seq_gen", sequenceName="user_details_userid_seq", allocationSize = 1)

where the parameter allocationSize = 1 defines your sequence-increment as 1.

Upvotes: 1

Related Questions