Get the next value from SequenceGenerator

jpa sequence-generators
Avin picture Avin · Jul 12, 2012 · Viewed 32.6k times · Source

I'd like to make use of SequenceGenerator and get the next value from the sequence generator. I want to avoid making a trip to the DB and rely on the sequencegenerator to give me a unique value. Also I am using the value to display the unique id in a display field without persisting the object.

Answer

staverk picture staverk · Dec 13, 2015

It works in Oracle:

Query q = em.createNativeQuery("SELECT nombreSecuencia.NEXTVAL FROM DUAL");

return (java.math.BigDecimal)q.getSingleResult();

Related questions

How does the JPA @SequenceGenerator annotation work

I am learning JPA and have confusion in the @SequenceGenerator annotation. To my understanding, it automatically assigns a value to the numeric identity fields/properties of an entity. Q1. Does this sequence generator make use of the database's increasing numeric …

Read More
@SequenceGenerator on class annotated with @MappedSuperclass

I have following structure of my entities: @MappedSuperclass public abstract class BaseEntity { @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seqGenerator") private Long id; } @MappedSuperclass @Inheritance(strategy = InheritanceType.SINGLE_TABLE) @SequenceGenerator(name = "seqGenerator", sequenceName = "DICTIONARY_SEQ") public abstract class Intermed extends BaseEntity {} @…

Read More
How to fix the Hibernate "object references an unsaved transient instance - save the transient instance before flushing" error

I receive following error when I save the object using Hibernate object references an unsaved transient instance - save the transient instance before flushing

Read More