I have a piece of Oracle SQL that returns me the next available sequence number. How do I execute this in Hibernate? The object I want to return (String), is NOT any of my Hibernate objects, but all the methods I can find to execute SQL apparently must return a Hibernate object.

The SQL I want to execute is this:
select transaction_seq.nextval from dual

To create the sequence I used:
CREATE SEQUENCE transaction_seq
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20

Regards
b

Use plain JDBC with Hibernate's connection.

or use <return-scalar> with H3

Thanks for the replies. Max, unfortunately I'm using H2. :( Alesj (or Max), could you please explain how to use JDBC with H2?

I changed my dialect to net.sf.hibernate.dialect.GenericDialect, which I would assume would use the default JDBC drivers, but that didn't solve my problem.

The Java code I am trying to execute, but which fails, is this:
List seqNo = getSession()
.createQuery("select transaction_seq.nextval from dual")
.list();
return (String)seqNo.get(0);

The dialect is this:
net.sf.hibernate.dialect.GenericDialect

But I also tried and failed with:
net.sf.hibernate.dialect.Oracle9Dialect

Thanks guys
b

the dialect should match your database.

using raw jdbc is just done by getting the connection from the session.
session.connect()