Search code examples
javasqlhibernatehql

Hibernate Generated Value strategy

I am using this code in hibernate.

@Id @GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="RightID", unique=true, nullable=false)

The problem is when i delete a row the 'RightId' don't remain in sequence. I want something like, hibernates should check id, if some id value is missing it must give that value to 'RightsId' otherwise proceed normally

Solution

  • Database do not care if there is holes in the sequence. Also in general it is possible and most likely easier to change application design so that it does not expect list of id values to not contain holes.

    If some odd reason forces such a design, you have to use custom generator. Implementation details can be found via this question: Hibernate ID Generator