Hibernate Community • View topic - How to get the next value in Oracle Sequence

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to get the next value in Oracle Sequence

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Post subject: How to get the next value in Oracle Sequence

Posted: Wed Sep 17, 2003 9:09 pm

Newbie

Joined: Wed Sep 17, 2003 9:02 pm
Posts: 13

Hi. Could you please tell me how to get the next value of an Oracle sequence.

I need the next value to do some processing before inserting. Normally, I would do "select sequence_name from dual" in Oracle. Do I need to define the "dual" table in Hibernate mapping?

If there is an easier way to get the next value of sequence without defining mapping for "dual", it will be great.

Your help is appreciated.

Regards,
KK

Top

steve

Post subject:

Posted: Wed Sep 17, 2003 9:17 pm

Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX

How about :

Code:

RsultSet results = session.getConnection().createStatement().executeQuery("select nextval from dual");
...

You would then need to NOT use the sequence id generation strategy, but assign the value you just retreived.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum