I hope this is not a old question.
I am writing a code where I need to get the next value from Oracle Sequence.

One way to do it from Hibernate is using SQLQuery ‘select Seq.nexval from dual’.
The problem is it doesn’t work on all DBs. (We use HSQL for Junit testing and it fails badly)

Another way is to use Hibernate Generator.
But I have always seen generator being used along with ‘id’ so it is auto-generated.
Is there a way I can use it with normal column (non-id-property) on demand.

Thanks
ankey