Pull from Oracle sequence with Hibernate

Question

I've a sequence defined in my Oracle database. Can I pull from this sequence using Hibernate? I don't want to use the sequence for generating ids for my objects, so @GeneratedValue and @Id are not the things I am looking for.

HamoriZ · Accepted Answer · 2010-12-13 14:00:16Z

2

Something like this:

  <sql-query name="sequenceValue">  
     <return alias="mySeq" class="MySequences"/>  
       select my_schema.seq_myid.nextval as mySeq from dual  
  </sql-query>

answered Dec 13, 2010 at 14:00

HamoriZ

2,45821 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rachel Over a year ago

How do we do it from hbm file?

RC. · Accepted Answer · 2010-12-13 13:00:25Z

2

Have you tried:

select my_schema.seq_myid.nextval from dual;

This will return a one record result set with the next value in your sequence. You can then use

select my_schema.seq_myid.currval from dual;

To get the current value of the sequence.

edited Dec 13, 2010 at 13:00

answered Dec 13, 2010 at 12:44

RC.

28.4k10 gold badges80 silver badges94 bronze badges

2 Comments

tobiasbayer Over a year ago

The key issue of my question is "...using Hibernate".

RC. Over a year ago

I understand, but I don't believe Hibernate explicitly does what you're asking to do. Therefore, you execute the query (using Hibernate) and you receive the data you're looking for.

Collectives™ on Stack Overflow

Pull from Oracle sequence with Hibernate

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related