Hi all,

I'm using Hibernate 3.0, I want to use the sequence generator with Oracle 9. But in the specification and Hibernate in Action I couldn't find an example how to mapping the generator with the name of the sequence I have defined in Oracle. I suppose this is trivial when you have done the first time, but until that moment...

Best Regards

Hi Rodolfo,

I am not shure if I understood you well, but for getting sequence in hibernate for given sequence name, you can use something like this.

Dialect dialec = Dialect.getDialect(super.getProperties());
String nextvalString = dialec.getSequenceNextValString("SEQSIGNAT");

But still I have no idea how to run nextvalString, so I have use the JDBC statement.

OK, thank you.

I thought it was possible to say the name of the secuence in the mapping.xml file and when you make an insert, Hibernate automaticly takes the next value an inputs. Anycase if you need to generate the next val by hand, in this case you can define the class generator as "assigned".

It would be possible to make transparent the fact of generate the next value. What do you think?

Best Regards

Rodolfo

http://www.hibernate.org/hib_docs/reference/en/html/mapping.html#mapping-declaration-id-sequences

Thanks Steve