hibernate postgres id incrementing in 10s

Question

I am getting a problem using hibernate with postgresql

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE)
@Column(name = "id")
private Long id;

the problem is the id is generating in 10s eg

10
20
30

How do I make it

1
2
3

What is your sequence's increment step? Isn't it 10? – Amir Pashazadeh Mar 01 '12 at 00:28 — Amir Pashazadeh, Mar 01 '12 at 00:28

score 0 · Answer 1 · edited May 23 '17 at 10:34

0

See hibernate allocationSize

Also see this - hibernate oracle sequence produces large gap

edited May 23 '17 at 10:34

Community

1
1

answered Mar 01 '12 at 00:39

Trever Shick

1,734
16
17

score 0 · Answer 2 · edited Mar 01 '12 at 16:42

0

As it has been pointed out, you shall use another annotation @javax.persistence.SequenceGenerator Here is how I did

@Id
@javax.persistence.SequenceGenerator(name = "order_id_sequence", sequenceName = "order_id_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "order_id_sequence")
@Column(name = "id")

edited Mar 01 '12 at 16:42

Toto

89,455
62
89
125

answered Mar 01 '12 at 05:28

vic

2,548
9
44
74

score 0 · Answer 3 · answered Mar 01 '12 at 20:38

Just so you know, you won't be able to rely on values from sequences not having gaps, as the database can't roll back the sequence in situations like:

Session A pulls a number, say 1, from the sequence.
Session B pulls a number, 2, from the sequence.
Session A rolls back its transaction.
Session B commits.

So, I would advise you to either not worry about it or use a different method for producing a series of unique numbers without gaps.

hibernate postgres id incrementing in 10s

3 Answers3