Reset Embedded H2 database periodically

reset h2
javydreamercsw picture javydreamercsw · Dec 15, 2011 · Viewed 58.4k times · Source

I'm setting up a new version of my application in a demo server and would love to find a way of resetting the database daily. I guess I can always have a cron job executing drop and create queries but I'm looking for a cleaner approach. I tried using a special persistence unit with drop-create approach but it doesn't work as the system connects and disconnects from the server frequently (on demand).

Is there a better approach?

Answer

Thomas Mueller picture Thomas Mueller · Dec 15, 2011

H2 supports a special SQL statement to drop all objects:

DROP ALL OBJECTS [DELETE FILES]

If you don't want to drop all tables, you might want to use truncate table:

TRUNCATE TABLE

Related questions

How to reset a form using jQuery with .reset() method

I had working code that could reset my form when I click on a reset button. However after my code is getting longer, I realize that it doesn't work anymore. <div id="labels"> <table class="config"> &…

Read More
Wipe data/Factory reset through ADB

Basically this is my problem/ I have 200+ phones running stock Android that need to be wiped (in the Wipe Data/Factory Reset way) and then a new ROM installed with some additional apks. Currently I've got everything automated except the …

Read More
Resetting a multi-stage form with jQuery

I have a form with a standard reset button coded thusly: <input type="reset" class="button standard" value="Clear" /> Trouble is, said form is of the multi-stage sort, so if a user fills out a stage & then …

Read More