Get from oracle sequence with hibernate

Question

I am working with hibernate, and a oracle 10 db. I need to get the next sequence value from a table, and want to know how. I saw this article, and asking: is there a better way the get the value, without defining a query?

Thanks!

GolezTrol · Accepted Answer · 2011-01-30 14:51:55Z

2

No. Getting the next (nextval) or current (currval) value from a sequence is typically done using a select. Even in PLSQL, SELECT INTO is used, like this:

SELECT YourSequence.NextVal INTO :new.ID FROM DUAL;

Simple assignment like this won't work:

:new.ID := YourSeqence.NextVal;

answered Jan 30, 2011 at 14:51

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

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

6 Comments

Rachel Over a year ago

So there is no way of doing this in hibernate?

Rachel Over a year ago

I have question here if you have some inputs then it would be really helpful...stackoverflow.com/q/11313854/164299

GolezTrol Over a year ago

Sounds like the same question, isn't it?

Rachel Over a year ago

Yes but is there a way to do this in hbm file?

H.Rabiee Over a year ago

@GolezTrol can you explain this docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/… and what are those annotations for? I thought that was an alternative

|

Collectives™ on Stack Overflow

Get from oracle sequence with hibernate

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related