[jbpm-issues] [JBoss JIRA] Commented: (JBPM-2509) database migration installation script

[ https://jira.jboss.org/jira/browse/JBPM-2509?page=com.atlassian.jira.plug... ] Tom Baeyens commented on JBPM-2509: ----------------------------------- i've set up already some pieces of the infrastructure. * in the modules/db, mvn -Pupgrade clean package will generate the upgrade scripts for all the db's in the db source files. * the upgrade scripts should be checked in (but with the applicable versioned directories) * using the qa databases (so everyone inside vpn should be able to run it) * the module also contains a DbUpgrade class which is the upgrade tool * the install/build.xml contains a target upgrade.jbpm.schema the tool will still have to be expanded. in order to have hibernate in the tool, the hibernate configuration has to be composed by the ant script before the tool is build. also where the tool fetches the sql file (from the file system or from the lib as resources). Alejandro, please think about how the tool will be completed and discuss that before you go ahead. currently, the initialization of the DbidGenerator somehow initializes the nextid property. but that should actually be moved into the db upgrade tool the developer aspects of this should be documented in wiki page that explains building from source the userguide should contain a description of how to use the tool we should also have this tool under continious integration. hudson job should create the old schema, run the upgrade tool and then run the test suite on the upgraded db. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira