nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Database upgrade - SQL generator

tvanhoec

Hey,
We work with Activiti 5.0 (in production) and we want to upgrade to Activiti 5.2 (oracle).

I understand that by changing the databaseSchemaUpdate param the schema should automatically be upgraded. As mentioned in the userguide this is however still experimental and backup is required.
<property name="databaseSchemaUpdate" value="true" />

Therefore my following question (on request off DBA's 😉 😞
Has someone writen a small program (or alike) that generates the SQL-statements to upgrade.

Thx!
Tom

Find more posts tagged with

Comments

frederikherema1

Hi Tom,

The scripts used to upgrade are shipped inside the activiti-engine jar-file. These upgrade-statements are written by hand for every feature added that affects the DB-schema.

These files are located here: /activiti-engine/src/main/resources/org/activiti/db/upgrade

These upgrades are tested on our QA-system on all DB's supported be it with minimal testing, thats why it's still marked experimental.

tombaeyens

First of all, it's best to wait for 5.3 which is delivered 1st of March. As I just fixed a number of problems with the upgrade from 5.0 to 5.1 in oracle.

Best is to run the upgrade in a test environment. That way you can 1) see the SQL statements in the logs and 2) check if your systems still runs fine on a copy of your production data