Manually using Oracle sequences

IGx89 · **Joined:** Fri Jul 28, 2006 10:53 am **Posts:** 15

How do I get the next value in an Oracle sequence in Hibernate? The corresponding SQL code is "select audit_control.nextval from dual".

mikekonikoff · **Joined:** Fri Oct 14, 2005 4:42 pm **Posts:** 15

You could do it this way:

Code:

Integer nv = (Integer)hbSession.createSQLQuery("select audit_control.nextval from dual").uniqueResult();

IGx89 · **Joined:** Fri Jul 28, 2006 10:53 am **Posts:** 15

I tried that, but Hibernate complained about being unable to map "dual"?

suranakamal · **Joined:** Sat Jul 29, 2006 3:36 pm **Posts:** 1

Try this -

Integer nv = (Integer)hbSession.createSQLQuery("select audit_control.nextval as ID from dual").addScalar("ID", Hibernate.INTEGER).uniqueResult();

IGx89 · **Joined:** Fri Jul 28, 2006 10:53 am **Posts:** 15

Unfortunately that didn't work either: "org.hibernate.exception.DataException: could not execute query"

I decided to add a sequence generator to a table mapping instead and that works fine, so finding an answer to this problem isn't very important any more now; I appreciate people trying to help though! It mystifies me why manually generating a sequence value isn't documented and thus at the moment is impossible to do :/