2 Replies Latest reply on Mar 3, 2007 10:09 AM by Bernd Ruecker

    Database change script from 3.1 to 3.2

    Bernd Ruecker Master


      There are some changes in the database from jbpm 3.1 to 3.2. For the Hibernate hbm2ddl it seems a little bit complicated, because he drops a lot of foreign keys and on my local computer he has not finished that yet, after 8 hours now!!

      Is there some out of the box conversion skript? Which I can look at and execute by hand?

      Would be nice

        • 1. Re: Database change script from 3.1 to 3.2
          Ronald van Kuijk Master

          This is what I found in /jbpm.3/jpdl/db/generate.schema.update.bat:

          @echo off
          ant -f build.upgrade.xml generate.old.schema
          ant -f build.upgrade.xml generate.update > target/schema.upgrade.log
          echo schema update generated in target/schema.upgrade.log

          No idea what it does....

          • 2. Re: Database change script from 3.1 to 3.2
            Bernd Ruecker Master

            Hi Ronald,

            thanks for that hint! Don't know, why I didn't found that myself. Was a hard week I think....

            I looked at that stuff a bit I could generate the update SLQ's for hsqldb with the following statements (in Windows):

            ant -f build.upgrade.xml generate.old.schema
            del target\db\localDB.lck
            ant -f build.upgrade.xml generate.update > target/schema.upgrade.log

            The batch file is not working (no idea why).

            To generate updates for MySQL I have changed the ant file a bit (not catch the hibernate.cfg.xml's, so I could overwrite them with my own and added the mySQL driver to the classpath).

            With that, I got some SQL's which have updated my database in about 5 minutes...