DB Upgrade JBPM 5.3.1 to 6.1

[maulee17]

Hi,

I have a web application, jbpm jars are bundled in war.

For migration I am considering following :

1. Jars update

2. API update

3. DB update - hbm mapping files update

4. Process Instance Upgrade.

Please let me know if I need to consider anything else. Also, How can I go for DB migration, just need to update the hbm files. I found a migration utility in the user guide, will it help ?

Thanks.

[swiderski.maciej]

here you can find some upgrade scripts for version 6 that might become useful. In general migrating from 5 to 6 should be just requiring upgrade of db schema. Stick to singleton runtime strategy for the first attempt and then you can move to more advanced strategies introduced in version 6.

HTH

[maulee17]

Hi Maciej,

Thank you for the pointer. Here there are db upgrade script from 6.0 to 6.1. My current version is 5.3. In the user guide they have mention only following script.

SELECT MAX(id) FROM nodeinstancelog;

-- Re-create the sequence by first dropping it and then creating a new one.

DROP SEQUENCE NODE_INST_LOG_ID_SEQ;

CREATE SEQUENCE NODE_INST_LOG_ID_SEQ START WITH 11 INCREMENT BY 1 NOCYCLE;

-- Increase the sequence (the result must be greater then the result obtained in step 1)

ALTER SEQUENCE NODE_INST_LOG_ID_SEQ INCREMENT BY 100;

There are no upgrade script available with jbpm-installer package 6.0, for 5.3 to 6 migration.

How should i move ahead ? How can I find the exact upgrade scripts.

Thanks.