Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)

by

These Annotations are no creating two sequences, only one. Is this correct/expected?

That’s the expected behavior. When using @GeneratedValue(strategy = GenerationType.AUTO), the JPA provider will pick an appropriate strategy for the particular database. In the case of Oracle, this will be SEQUENCE and, since you did not specify anything, Hibernate will use a single global sequence called hibernate_sequence.

Is this correct? Well, I don’t know, it depends on your needs. Just in case, the default maximum value for an Oracle sequence is 1E+27, or 1,000,000,000,000,000,000,000,000,000. That’s enough for many.

Now, it is possible to use GenerationType.AUTO and still control the name of the sequence when the database uses sequences:

@Id
@GeneratedValue(strategy=GenerationType.AUTO, generator="my_entity_seq_gen")
@SequenceGenerator(name="my_entity_seq_gen", sequenceName="MY_ENTITY_SEQ")
private Long id;

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. Difference between FetchType LAZY and EAGER in Java Persistence API?
  3. How to map a composite key with JPA and Hibernate?
  4. How to map an entity field whose name is a reserved word in JPA
  5. Do I need elements in persistence.xml?
  6. What’s the difference between JPA and Hibernate? [closed]
  7. Hibernate Error: org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session
  8. What is the “owning side” in an ORM mapping?
  9. What is the solution for the N+1 issue in JPA and Hibernate?
  10. JPA CascadeType.ALL does not delete orphans
  11. What is the difference between persist() and merge() in JPA and Hibernate?
  12. Do Hibernate table classes need to be Serializable?
  13. How to solve the LazyInitializationException when using JPA and Hibernate
  14. Hibernate: flush() and commit()
  15. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  16. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  17. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  18. Hibernate could not fetch the SequenceInformation from the database
  19. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  20. Is there such thing CASE expression in JPQL?
  21. How to call an Oracle function from Hibernate with a return parameter?
  22. Doing an “IN” query with Hibernate
  23. The onFlushDirty Hibernate Interceptor method is never called
  24. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  25. Batch inserts with JPA/EJB3
  26. Connection cannot be cast to oracle.jdbc.OracleConnection
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. Difference between @GeneratedValue and @GenericGenerator
  30. getting result set into DTO with native SQL Query in Hibernate

Leave a Comment