Hi All,

This is my first posting.

We are using Hibernate 3 ,Spring 2 and Mysql 5.
The problem is for Id generator we are using hilo algorithm and the primary key generated is very high, the id is not in sequence it keeps on jumping high. the ids are as high as 8 digits.

For ex: 26568934,26768934,26968934

these numbers keep on jumping by around 20000.

Not sure why is this happening.

I am afraid if these numbers keep on jumping, all numbers might get exhausted.

Any pointers on this issue ?

Thanks
Sandeep

What's the HiLo configuration? Remember with HiLo generation, HB reserves a range of ids each time it starts or it runs out of ids and you lose that range if the application restarts. Therefore, it makes a lot of sense in test environments if HiLo generated ids are big numbers. However, the amount HB reserves is (should be) configurable and you might want to set that to a small number in a test environment.


Farzad-

You may want to look at this: http://forum.hibernate.org/viewtopic.php?t=929583&sid=96a22fa6a94faaaa4601b5074e95ce0b


Farzad-

hi Farzad,

thanks for your reply.

Can you point me to some documentation which explains how Hilo works ?

Also, if its reserves a range of ids each time then will it again go back to the non-used ids ?

for eg: if it starts with say 250000 and moves forward and at somepoint if all numbers get exhausted, will get use the numbers below 250000 this time?