Hibernate use of PostgreSQL sequence does not affect sequence table

by

I had the same problem. It is related to the id allocating strategies of Hibernate. Whe n you choose GenerationType.SEQUENCE, Hibernate uses HiLo strategy which allocates IDs in blocks of 50 by default. So you can explicitly set allocationSize value like this:

@Id 
@SequenceGenerator(name="pk_sequence",sequenceName="entity_id_seq", allocationSize=1)
@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="pk_sequence")
@Column(name="id", unique=true, nullable=false)
public int getId() {
    return this.id;
}

Though, I’ve also heard opinions that using HiLo strategy with allocationSize=1 is not a good practice. Some people recommend to use GenerationType.AUTO instead when you have to deal with database-managed sequences

Update: I did end up going with allocationSize=1, and things seem to work as I expect now. My application is such that I don’t really need blocks of IDs anyway, so YMMV.

More Related Contents:

  1. Postgresql UUID supported by Hibernate?
  2. How to map calculated properties with JPA and Hibernate
  3. How to map a PostgreSQL array with Hibernate
  4. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  5. Hibernate throws strange error: Class is not mapped
  6. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  7. Hibernate saving User model to Postgres
  8. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  9. What is lazy loading in Hibernate?
  10. Mapping PostgreSQL JSON column to a Hibernate entity property
  11. Why does Hibernate require no argument constructor?
  12. proper hibernate annotation for byte[]
  13. JPQL Create new Object In Select Statement – avoid or embrace?
  14. org.hibernate.MappingException: Could not determine type for: java.util.List, at table: College, for columns: [org.hibernate.mapping.Column(students)]
  15. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  16. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  17. JPA/Hibernate Native Queries do not recognize Parameters
  18. Difference Between One-to-Many, Many-to-One and Many-to-Many?
  19. Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.(I)V
  20. Hibernate Named Query Order By parameter
  21. How to perform a non-polymorphic HQL query in Hibernate?
  22. Is it possible to dynamically define column names in Hibernate / JPA?
  23. How do you map a “Map” in hibernate using annotations?
  24. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  25. Persisting UUID in PostgreSQL using JPA
  26. Batch inserts with JPA/EJB3
  27. PSQLException: ERROR: relation “TABLE_NAME” does not exist
  28. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  29. Hibernate @PostLoad never gets invoked
  30. HQL recursion, how do I do this?

Leave a Comment