Getting the next sequence number

tt_linux · **Joined:** Mon Jan 09, 2006 8:17 am **Posts:** 19

hi,

How can i get the next sequence number from a table ?

In Java API (JPA), there is something like that:

Long nextId = (Long) em.createNativeQuery("select nextval('user_id_seq'").getSingleResult();

I need the equivalent in Hibernate.

Thanks for helping.

Hibernate version: 3.1

regards
tony

Kayaman · **Posted:** Thu Feb 15, 2007 6:14 am

You can use Session.createSQLQuery() to do native SQL.

-Jussi

tt_linux · **Joined:** Mon Jan 09, 2006 8:17 am **Posts:** 19

Kayaman wrote:

You can use Session.createSQLQuery() to do native SQL.

-Jussi

how do i do it ? it needs to be database independent ...

max · **Posted:** Thu Feb 15, 2007 7:14 am

you are using something db specific so very hard to make it independent.

you will need to create the query string per db and then select the right one at runtime.

tt_linux · **Joined:** Mon Jan 09, 2006 8:17 am **Posts:** 19

max wrote:

you are using something db specific so very hard to make it independent.

you will need to create the query string per db and then select the right one at runtime.

ok. thanks. looks like i will need a file that serves the sequence #.