Database change script from 3.1 to 3.2

[camunda]

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

[kukeltje]

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

[camunda]

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