1 Reply Latest reply on Oct 13, 2005 10:23 PM by Brian Bulthuis

    clearing the jbpm database

    Ashwini Kumar Newbie

      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.

        • 1. Re: clearing the jbpm database
          Brian Bulthuis Newbie

          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.