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.
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.