Manual upgrade throwing ActivitiWrongDbException

Description

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.

Code:
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

Environment

None

Assignee

Frederik Heremans

Reporter

Indrani Boppana

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure