hi,

I want to use next value of a sequence so that i can assign this value to an attribute in my object before persisting it in database.
I can't use <generator class="sequence"> as this attribute is not the primary key for my table and i am already using <generator class="uuid"> uuid for the same table.
When i create my HQL query using DUAL it gives me an exception saying that DUAL is not mapped.

Kindly help me with this problem.
Thanks in advance.

Hibernate will generate the sequence number for you at insert time, you don't even need to worry about that.

Kindly elaborate more.

I didnt get how hibernate can link a sequence to my attribute? just to mention again, i am not using <generator class="sequence"> as this attribute is not my primary key.

Besically i have two coloumns in my table.
One is uuid which gets generated by hibernate using <generator class="uuid">
and other one is hrid which i want to be sequential.

Now I dont know how to use sequence to generate values for hrid.
Knidly suugest some solution.

Thanks

OK, sorry, I misread... According to:

http://docs.jboss.org/hibernate/stable/ ... rated.html

and:

http://docs.jboss.org/hibernate/stable/ ... n-property

Hibernate will, in fact, not generate the sequence for you. It only does so for primary keys, which is curious.

True.
Basically i am looking for HQL equilvalent of this SQL query now..
"select main_sequence.NEXTVAL from DUAL"

Any idea?

Thanks

i am running SQL query instead of HQL to generate nextval, updating my object with it and then persisting using hibernate.
It work for me! :)