calling sequences in hibernate

[Viswanath Sriram]

Hi,

How to call sequences from hibernate.I want the sequence value.

(Removed E-mail so the user doesn't get tons more spam - Mark)
[ July 20, 2006: Message edited by: Mark Spritzler ]

[pascal betz]

no. please do not email.
please use the forum to give an answer (or is your email account also indexed by the javaranch search ?)

cheers
pascal

[Mark Spritzler]

Well you have configured the ID to use the sequence already using generator set to sequence, then giving it the name of the sequence.

You can always write SQL to call a query like "select seq.currval from dual" and run it. or use nextval instead of currval.

Why do you need it, should you just let Hibernate when it calls insert to use the sequence, and then I believe after that you can get what was set into the Object.

Mark