This is what I found in /jbpm.3/jpdl/db/generate.schema.update.bat:
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....
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...