I am using Hypersonic DB during development and plan to switch over to Oracle at a future date. I will be working with new data in Oracle and plan to use sequences to generate ids for all my tables. In development I have been using import.sql to load some test data into HSQL. My question is how should I go about using some auto generation strategy for primary keys when seeding my database with test data?

Note: I am Hibernate for JPA

Should I just find my highest valued id in the test data and use a Table Generation strategy with the value in the table set higher than my biggest id in the test data?

Is there some way to use the generation strategy in my insert statements inside import.sql similar to how Oracle sequences work sequence_name.next_val()?

How have others tackled this?

Thanks