Hi,

I am new to Hibernate , I have developed an application using Hibernate with Annotations

I am trying to populate ID column using @GeneratedValue(strategy=GenerationType.IDENTITY) its working fine for the single session but when i starts a new session the sequence is not in a continuous fashion

i.e; for the first run i have inserted 10 values and it populates 1 to 8 for those 8 columns and when i start the next session and tries to insert another 2 rows it is populating as 81 and 82 rather 9 and 10

I have tried with all the defaults available with that GenerationType .

How could i overcome this

please help me out


Thanks in advance

With strategy=GenerationType.IDENTITY you could have sequence in a continuous fashion,
if your database would support 'identity columns' like for example DB2, MySQL, MSSQL, Sybas, HSQLDB are doing.
Apparently your database does not and so hibernate uses a sequence or hilo for generating identifiers.
With this implementations it is normal that there will be gaps in the ID's sequence as you describe.
It is because each HibernateSessionFactory is allocating a entire ranges of numbers, in order to avoid to frequent accesses to the sequence.
But this number gaps are absolutely no problem, the number range is big enough and will not run out of numbers.