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

[confluence]

Page Edited : ODExSITE : Upgrading ODE Upgrading ODE has been edited by Alexis Midon (Apr 22, 2009). (View changes) Content: from 1.2 to 1.3.1 For Hibernate database schema 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