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

      Hi!

      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
      Thanks
      Bernd

        • 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...