Hibernate init DB

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Hey,

I work with Jboss and ejb3.

Hibernate is generate the tables in case that they dont exists during the server startup.

I need to insert some entries after the schema was created and before the application is started.
Does any one know how to do this?

I cant use jboss-sar because the database wasnt created when the sar loaded.

Thank you

ge0ffrey · **Joined:** Thu Oct 13, 2005 4:19 am **Posts:** 98

Inject the EntityManager(Factory) in an bean that listens to server startup (in spring that would be a IntializingBean, idunno what interface it is in EJB3).
Normally the EntityMangerFactory should be created by then and the database should be populed with it's tables by hibernate, so you can use for example dbunit to insert the starting data then.

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

persistence unit and my persistence unit scan for 4 jars that the startup donst know all.

emmanuel · **Posted:** Thu Jan 10, 2008 1:58 pm

you can use a file named /import.sql to do that. it will be read and executed by hibernate

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

Thank you

avihaimar77 · **Joined:** Wed May 02, 2007 2:42 pm **Posts:** 101

There is problem to hibernate in case that the insert is not written in one row.

ge0ffrey · **Joined:** Thu Oct 13, 2005 4:19 am **Posts:** 98

emmanuel wrote:

you can use a file named /import.sql to do that. it will be read and executed by hibernate

Nice :)
Any way to rename that file?

Is it possible to execute some java code too? Like for example a class that calls DBUnit?

emmanuel · **Posted:** Fri Jan 11, 2008 6:57 am

no the file cannot be renamed, it's a simple way to execute SQL operations at SF startup, that's it.