Reverse engineer DDL from JPA entities

Gaurav picture Gaurav · Apr 23, 2009 · Viewed 18.8k times · Source

I'm playing around with some JPA stuff, changing the mappings to see how they're supposed to be etc. It's basic experimentation. However I can't find a tool that will simply read my entities and then generate the table schema for me. I tried to find something like this in JBoss tools but nada. Eclipse integration will be a huge plus but i'll take a command line tool or an ant task.

Any ideas?

Answer

James McMahon picture James McMahon · May 15, 2009

Try adding the following to your persistence.xml

For Hibernate:

To create:

<property name="hibernate.hbm2ddl.auto" value="update"/>

To drop and create:

<property name="hibernate.hbm2ddl.auto" value="create-drop"/>

For Toplink:

To create:

<property name="toplink.ddl-generation" value="create-tables"/>

To drop and create:

<property name="toplink.ddl-generation" value="drop-and-create-tables"/>

For EclipseLink:

To create:

<property name="eclipselink.ddl-generation" value="create-tables"/>

To drop and create:

<property name="eclipselink.ddl-generation" value="drop-and-create-tables"/>