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
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