clearing the jbpm database

[ashkumar]

Is there is general purpose script to clear the entire jbpm database? There are a lot of integrity constraints that prevent deleting records in the database. So, there has to be a sequence in which we have to issue delete statements.
Thanks,

[brianmb99]

If you built the database creation scripts in jbpm-db-3.0.x, one of the built scripts is "databasename.clean.sql". I think that's what you're looking for.

I'm using mysql, and the mysql clean script has some problems for me, so I've just been dropping the database and using "mysql.create.sql" to recreate the tables when I want to refresh the db.