Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]

Hi..

I am using Hibernate 3.1 with Oracle 8
I am trying to get the next value from a sequence.
My sequence name is userId

I tried session.createQuery("select userId.nextVal from dual");
but hibernate returns with "dual not mapped"

Any help is really appreciated,
Shanth

You have to use createSQLQuery instead of createQuery (HQL Query) because you are trying to execute a native SQL query,

Thanks a lot ChristianS