Hibernate generates negative id values when using a sequence

by

The new behaviour is the followings:

AllocationSize is a range of primary key values reserved for Hibernate.
And the select seq.nextval from dual will be done only after hibernate consumed this range of primary keys.

So you must declare the same value on both allocationSize (Hibernate) and sequence increment by (DB)

When explicitly set allocationSize=500, e.g. on Oracle

create sequence SEQ_ACE_WORKERS_QUEUE_STATS_ID
       MINVALUE 1 
       MAXVALUE 999999999999999999999999999 
       START WITH 1
       INCREMENT BY 500 
       NOCACHE 
       NOCYCLE;

Otherwise, you’ll notice negative values or constraint errors raised from your DB because of primary key collisions.

When the app server is restarted, you’ll notice the ‘jump’ between the latest primary key allocated, and the ‘newly’ sequence number selected at restart.

Final comment: default value is 50. So if you don’t specify allocationSize on the Hibernate side, you must declare increment by 50 on the DB side.

More Related Contents:

  1. JPA CascadeType.ALL does not delete orphans
  2. Hibernate – @ElementCollection – Strange delete/insert behavior
  3. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  4. Silently ignored remove()
  5. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  6. Hibernate triggering constraint violations using orphanRemoval
  7. Change Table Name of an Entity on runtime? [duplicate]
  8. Hibernate throws MultipleBagFetchException – cannot simultaneously fetch multiple bags
  9. Hibernate Annotations – Which is better, field or property access?
  10. Hibernate JPA Sequence (non-Id)
  11. How to store date/time and timestamps in UTC time zone with JPA and Hibernate
  12. Bypass GeneratedValue in Hibernate (merge data not in db?)
  13. How does the FetchMode work in Spring Data JPA
  14. How to properly express JPQL “join fetch” with “where” clause as JPA 2 CriteriaQuery?
  15. JPA SQL Server No Dialect mapping for JDBC type: -9
  16. @GeneratedValue polymorphic abstract superclass over MySQL
  17. JPA entity without id
  18. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  19. Multiple fetches with EAGER type in Hibernate with JPA
  20. Could not commit JPA transaction: Transaction marked as rollbackOnly
  21. GenerationType.AUTO vs GenerationType.IDENTITY in hibernate
  22. Native query with named parameter fails with “Not all named parameters have been set”
  23. @BatchSize a smart or stupid use?
  24. Spring Data JPA and Exists query
  25. Error creating bean with name ‘entityManagerFactory
  26. HQL joined query to eager fetch a large number of relationships
  27. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  28. What properties does @Column columnDefinition make redundant?
  29. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  30. JPA Updating Bidirectional Association

Leave a Comment