I need to know what's the easiest way to get the nextval from a sequence via Hibernate. This sequence is not for a primary key for an object.

I just need an integer returned when this sql is run - "select seq_name.nextval from dual"

Thanks

just create a sql query and run it.

Figured it out.

whether say

select OCCASION_ADDRESS_SEQ.nextval from dual holds good.
if so whether we need to write in this format
<sql-query>
...
..
</sql-query>

or is there any other way .

i'm a tyro to hibernate , i'm facing the same problem .
can u educate me in this .

also i'm using spring + hibernate . so i will be using HibernateDAOSupport class .

Use getHibernateTemplate().execute and pass it a HibernateCallback. The HibernateCallback exposes a Hibernate Session to you, on which you can then call createSQLQuery. I'll leave it to you to figure out exactly how to use that method because I've never done so.

thanks this is working