Seed data tooling with Hibernate

ihanen · **Joined:** Thu May 05, 2005 2:57 pm **Posts:** 2

Hi everyone,

I am using Hibernate on top of my database. I am looking for a way to create a database schema AND insert seed data inside some tables of the schema that has been created. The "schemaexport" feature from the Hibernate tools helps me to create the correct schema for now, but I don't know how to insert the seed data into the tables.

Does anybody know about any toolkit I could use to create schema files declaratively, and then declaratively insert seed data into some of the tables?

Best regards,
Iannis

max · **Posted:** Thu May 05, 2005 5:38 pm

its a tool we would like to do (its on our todo/roadmap), but nothing solid yet. contributions welcome!

ihanen · **Joined:** Thu May 05, 2005 2:57 pm **Posts:** 2

Hi Max,

Thank you for your reply.

Do you know of any tool that could provide me with this functionality outside of the Hibernate world? This is assuming that I use this tool for both schema creation and seed data insertion (Then hibernate will just use the created schema without creating it itself).

Best Regards,
Iannis

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

try dbjunit

david · **Posted:** Thu May 05, 2005 10:20 pm

I use dbUnit for doing this type of work. Works very well for me.

alexandrupopescu · **Posted:** Fri May 06, 2005 2:37 am

For generating large quantities of test data I use DataFactory from Quest. It is not able to generate your schema, but it is using reverse to read it and than you have lots of customizations for the data to be generated.