Hibernate finding the current value for sequence

J

javed

HI there i have a seqeunce called SEQ_ESTAMPILLE :

CREATE SEQUENCE SEQ_ESTAMPILLE
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;

I would like to know how using hibernate i can retrieve the current
value of sequence SEQ_ESTAMPILLE from dual.

i tried the following SQL statement :
select SEQ_ESTAMPILLE.currval from dual

but i get the following error:
net.sf.hibernate.QueryException: undefined alias: SEQ_ESTAMPILLE
[select SEQ_ESTAMPILLE.currval from dual]

can anyone help please,
regards,
Javed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,432
Messages
2,571,680
Members
48,796
Latest member
Greg L.

Latest Threads

Top