Hi,

I am quite new to Hibernate.
I have set the PK of database as Generator Increment type.
Suppose i have 5 rows and i add one row then the ID is set to 6 which is correct.
Now i delete 6th row so there are only 5 rows in the table with ID values 1 to 5 and i commit this change.

Now again when i try to add ID value it automatically sets it to 7 although there are 5 rows in table and 6 th row is deleted. I tried select max(ID) from Table. which gives me 5 as output,
Then from where hibernate finds out that 6 th row was added.
Or is it suppose to work this way?

Thanks.

This is the way it works. Is there any reason for you to keep your IDs continuous?

Yes, I mean i don't want to unnecessarily block primary key (ID) for the records which don't exist. which were added but deleted. I want to set the Increment ID to the max(ID) + 1 .( for e.g there are 10 records then 11 and not 21 assuming that there were 20 records once upon a time)

How to achive this?

You can write your own sequnce generator which does

Howewer, I would not recommend chasing this goal. You may run into undesired lock on your table.