[CONF] Apache Ode: Upgrading ODE (page edited)

Mon, 11 May 2009 12:07:32 -0700

Page Edited : ODExSITE : Upgrading ODE

Upgrading ODE has been edited by Alexis Midon (May 11, 2009).

(View changes)

Content:
You shall backup
Always back up your database before upgrading!

ODE upgrade procedures usually consist in:

  1. backing up your database
  2. checking your backup
  3. double-checking your backup
  4. running the required SQL upgrade script
  5. deploying your new ODE war.
  6. copying all the previous configuration and deployed processes (with the corresponding markers).

from 1.2 to 1.3.2

If you're currently using ODE 1.2 and are upgrading to 1.3.2, please run the following queries.

For OpenJPA database schema

create table ODE_SCHEMA_VERSION (VERSION integer);
insert into ODE_SCHEMA_VERSION values (5);

alter table ODE_MESSAGE_EXCHANGE add column (SUBSCRIBER_COUNT integer);
alter table ODE_MESSAGE_ROUTE  add column (ROUTE_POLICY character varying(255));

For Hibernate database schema

(Mind the table names)

create table ODE_SCHEMA_VERSION(VERSION integer);
insert into ODE_SCHEMA_VERSION values (5);

alter table BPEL_MESSAGE_EXCHANGE add column (SUBSCRIBER_COUNT integer);
alter table BPEL_SELECTORS  add column (ROUTE_POLICY character varying(255));

from 1.1 to 1.2

The upgrade path from 1.1 to 1.2 is relatively simple as there haven't any major change in the database or runtime models. Still, if you use the Hibernate database schema, one column has been added so you will need to execute the following upgrade script (make sure to backup before to prevent any data loss):

alter table BPEL_SELECTORS add column (PROC_TYPE varchar(255));
update BPEL_PROCESS p, BPEL_CORRELATOR c, BPEL_SELECTORS s set s.PROC_TYPE = ('{' + p.type_ns + '}' + p.type_name) where s.CORRELATOR = c.CID and c.PROCESS_ID = p.PROCID;

The update statement is only necessary if you have currently running instances. Note that if you're using the default OpenJPA database schema, no database modifications are necessary. Once this is done, it's fairly simple:

  • Redeploy your new ODE 1.2 WAR.
  • Copy all the previous configuration and deployed processes (with the corresponding markers).

That's it!

Powered by Atlassian Confluence (Version: 2.2.9 Build:#527 Sep 07, 2006) - Bug/feature request

Unsubscribe or edit your notifications preferences

Reply via email to