Drop-and-create-tables in OpenJPA

By , 6 March 2008

Drop-and-create-tables in OpenJPA

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!

Drop-and-create-tables in OpenJPA

About Roger Keays

Drop-and-create-tables in OpenJPA

I guess I'd call myself a problem solver. Either that, or I'm some sort of organic machine designed to convert oxygen into carbon dioxide. You could go either way on that. I'm into languages and stuff. I wrote a book. It's okay, I guess. What else? I like reading, swimming, eating, and playing music. Satisfied? Sheesh.

Leave a Comment

Please visit https://rogerkeays.com/blog/drop-and-create-tables-in-openjpa to add your comments.