Hibernate version: 2.1.6

I use the native id generator and have seen that for Oracle one sequence is used for all tables. Since I initialize the database with some default data, this leads to errors because the seuqence starts at 1 by default. I solve this by setting the sequence to my highest id in my initial data.

I'm regaled by MySQL's autoincrement on a table basis. So I'm looking for a better solution for Oracle in the same matter? Do you have an advice? (Unfortunately I'm bound to Integer/Long identifiers)

Thanks in advance
Thomas

Thats the nature of sequences. They are decoupled.

Its easy to write a PLSQL routine to get the max(id) on the table(s) to reset the appropriate sequence(s).

BTW: You can have individiual sequences per-table for native just set the sequence name in the parameter as you would for the sequence generator.

Hi David,

thanks a lot. This helps me going the right way.

Thomas