Hi,

I can't get the syntax right for the parameter for an oracle style create sequence. I have:


where would I change this to include:
INCREMENT BY 1 START WITH 1 MAXVALUE 100 NOCACHE

Thanks,
Phil Hersh

Could this be any help?
http://www.hibernate.org/296.html

Hi,

Thanks kgignatyev, but no. I'm using the hbm2ddl.SchemaExportTask which reads the hbm files and generates the tables, indexes and sequences directly into my database.

I'd like to embed the parameters directly into the hbm file so the newly generated sequences start with a value higher than the test data I have inserted using dbunit.

If I can add a parameter to the hbm files to start the sequences with higher key id values than those already used in my test data, I won't need to change the sequences via Oracle stored procedure or java code (or ugh manually) eliminating a step from my build and test cycle.

Thanks,
Phil