Drop-and-create-tables in OpenJPA

Posted by Roger Keays, 6 March 2008, 1:56 PM

Toplink had a useful drop-and-create-tables options which made unit testing a lot easier because you always new you were testing a fresh database. Well, I've been trying to do the same thing in OpenJPA and couldn't figure it out until I found this JIRA issue: OPENJPA-94.

The nearest equivalent in OpenJPA is the following obscure setting:

openjpa.jdbc.SynchronizeMappings=buildSchema(SchemaAction='add,deleteTableContents')

It is actually faster than the Toplink method because the tables aren't recreated, they are just updated and emptied. It'd just be nice if it had a sensible name, and appeared in the docs somewhere!