Upgrading existing application from Activiti 5.8 to 5.9. Our deployments all have <property name="databaseSchemaUpdate" value="false"/> set because we need to control this process manually.
So we located the upgrade script org\activiti\db\upgrade\activiti.oracle.upgradestep.58.to.59.engine.sql and executed it on the target schema connected as an admin user. This worked fine, no errors. However restarting the application caused this exception
Caused by: org.activiti.engine.ActivitiWrongDbException: version mismatch: activiti library version is '5.9', db version is 5.8 Hint: Set <property name="databaseSchemaUpdate" to value="true" or value="create-drop" (use create-drop for testing only!) in bean processEngineConfiguration in activiti.cfg.xml for automatic schema creation
Can we not make the upgrade script self-contained so that upgrades can be more easily managed .
For now we did this and it seems to be ok.
UPDATE act_ge_property SET value_ = '5.9' WHERE name_='schema.version';
Related issue in activiti forum - http://forums.activiti.org/en/viewtopic.php?f=4&t=3597