Author: buildbot
Date: Mon Dec 10 21:26:57 2012
New Revision: 841537
Log:
Staging update by buildbot for ode
Modified:
websites/staging/ode/trunk/content/ (props changed)
websites/staging/ode/trunk/content/upgrading-ode.html
Propchange: websites/staging/ode/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Mon Dec 10 21:26:57 2012
@@ -1 +1 @@
-1419779
+1419786
Modified: websites/staging/ode/trunk/content/upgrading-ode.html
==============================================================================
--- websites/staging/ode/trunk/content/upgrading-ode.html (original)
+++ websites/staging/ode/trunk/content/upgrading-ode.html Mon Dec 10 21:26:57
2012
@@ -81,85 +81,75 @@
<div class="row">
<div class="span12">
- <div class="alert alert-note"><h4 class="alert-heading">You shall
backup</h4>
- ODE upgrade procedures usually consist in:
- # backing up your database
- # checking your backup
- # double-checking your backup
- # running the required SQL upgrade script
- # deploying your new ODE war.
- # copying all the previous configuration and deployed processes (with the
corresponding markers).
+ <div class="alert alert-note"><h4 class="alert-heading">You shall
backup</h4></div>
- h2. From 1.3.3 to 1.3.4
-
- First, apply SQLs to denormalize LARGE_DATA table from here:
[https://issues.apache.org/jira/browse/ODE-694]
-
- Then, please apply following updates:
-
- {code}
- alter table BPEL_XML_DATA add SIMPLE_VALUE varchar2(255);
-
- create table ODE_JOB_BAK as select * from ODE_JOB;
- alter table ODE_JOB add instanceId number(37);
- alter table ODE_JOB add mexId varchar(255);
- alter table ODE_JOB add processId varchar(255);
- alter table ODE_JOB add type varchar(255);
- alter table ODE_JOB add channel varchar(255);
- alter table ODE_JOB add correlatorId varchar(255);
- alter table ODE_JOB add correlationKeySet varchar(255);
- alter table ODE_JOB add retryCount int;
- alter table ODE_JOB add inMem int;
- alter table ODE_JOB add priority int;
- alter table ODE_JOB add detailsExt blob;
- update ODE_JOB oj set detailsExt = (select details from ODE_JOB where
jobid = oj.jobid);
- alter table ODE_JOB drop column details;
-
- {code}
-
- h2. From 1.3.2 to 1.3.3
-
- None
-
- h2. 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.
-
- h3. For OpenJPA database schema
- {code:sql}
- 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));
- {code}
-
- h3. For Hibernate database schema
-
- (Mind the table names)
-
- {code:sql}
- 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));
- {code}
-
- h2. 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):
-
- {code:sql}
- 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;
- {code}
-
- 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\!
+<p>ODE upgrade procedures usually consist in:</p>
+<ul>
+<li>backing up your database</li>
+<li>checking your backup</li>
+<li>double-checking your backup</li>
+<li>running the required SQL upgrade script</li>
+<li>deploying your new ODE war.</li>
+<li>copying all the previous configuration and deployed processes (with the
corresponding markers).</li>
+</ul>
+<h2 id="from-133-to-134">From 1.3.3 to 1.3.4</h2>
+<p>First, apply SQLs to denormalize LARGE_DATA table from here:
[https://issues.apache.org/jira/browse/ODE-694]</p>
+<p>Then, please apply following updates:</p>
+<div class="codehilite"><pre><span class="k">alter</span> <span
class="k">table</span> <span class="n">BPEL_XML_DATA</span> <span
class="k">add</span> <span class="n">SIMPLE_VALUE</span> <span
class="n">varchar2</span><span class="p">(</span><span
class="mi">255</span><span class="p">);</span>
+
+<span class="k">create</span> <span class="k">table</span> <span
class="n">ODE_JOB_BAK</span> <span class="k">as</span> <span
class="k">select</span> <span class="o">*</span> <span class="k">from</span>
<span class="n">ODE_JOB</span><span class="p">;</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">instanceId</span> <span class="nb">number</span><span
class="p">(</span><span class="mi">37</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">mexId</span> <span class="nb">varchar</span><span
class="p">(</span><span class="mi">255</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">processId</span> <span class="nb">varchar</span><span
class="p">(</span><span class="mi">255</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span class="k">type</span>
<span class="nb">varchar</span><span class="p">(</span><span
class="mi">255</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">channel</span> <span class="nb">varchar</span><span
class="p">(</span><span class="mi">255</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">correlatorId</span> <span class="nb">varchar</span><span
class="p">(</span><span class="mi">255</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">correlationKeySet</span> <span class="nb">varchar</span><span
class="p">(</span><span class="mi">255</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">retryCount</span> <span class="nb">int</span><span class="p">;</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">inMem</span> <span class="nb">int</span><span class="p">;</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">priority</span> <span class="nb">int</span><span class="p">;</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">add</span> <span
class="n">detailsExt</span> <span class="nb">blob</span><span class="p">;</span>
+<span class="k">update</span> <span class="n">ODE_JOB</span> <span
class="n">oj</span> <span class="k">set</span> <span
class="n">detailsExt</span> <span class="o">=</span> <span
class="p">(</span><span class="k">select</span> <span class="n">details</span>
<span class="k">from</span> <span class="n">ODE_JOB</span> <span
class="k">where</span> <span class="n">jobid</span> <span class="o">=</span>
<span class="n">oj</span><span class="p">.</span><span
class="n">jobid</span><span class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_JOB</span> <span class="k">drop</span> <span
class="k">column</span> <span class="n">details</span><span class="p">;</span>
+</pre></div>
+
+
+<h2 id="from-132-to-133">From 1.3.2 to 1.3.3</h2>
+<p>None</p>
+<h2 id="from-12-to-132">From 1.2 to 1.3.2</h2>
+<p>If you're currently using ODE <em>1.2</em> and are upgrading to 1.3.2,
please run the following queries.</p>
+<h3 id="for-openjpa-database-schema">For OpenJPA database schema</h3>
+<div class="codehilite"><pre><span class="k">create</span> <span
class="k">table</span> <span class="n">ODE_SCHEMA_VERSION</span> <span
class="p">(</span><span class="k">VERSION</span> <span
class="nb">integer</span><span class="p">);</span>
+<span class="k">insert</span> <span class="k">into</span> <span
class="n">ODE_SCHEMA_VERSION</span> <span class="k">values</span> <span
class="p">(</span><span class="mi">5</span><span class="p">);</span>
+
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_MESSAGE_EXCHANGE</span> <span class="k">add</span> <span
class="k">column</span> <span class="p">(</span><span
class="n">SUBSCRIBER_COUNT</span> <span class="nb">integer</span><span
class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">ODE_MESSAGE_ROUTE</span> <span class="k">add</span> <span
class="k">column</span> <span class="p">(</span><span
class="n">ROUTE_POLICY</span> <span class="nb">character</span> <span
class="nb">varying</span><span class="p">(</span><span
class="mi">255</span><span class="p">));</span>
+</pre></div>
+
+
+<h3 id="for-hibernate-database-schema">For Hibernate database schema</h3>
+<p>(Mind the table names)</p>
+<div class="codehilite"><pre><span class="k">create</span> <span
class="k">table</span> <span class="n">ODE_SCHEMA_VERSION</span><span
class="p">(</span><span class="k">VERSION</span> <span
class="nb">integer</span><span class="p">);</span>
+<span class="k">insert</span> <span class="k">into</span> <span
class="n">ODE_SCHEMA_VERSION</span> <span class="k">values</span> <span
class="p">(</span><span class="mi">5</span><span class="p">);</span>
+
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">BPEL_MESSAGE_EXCHANGE</span> <span class="k">add</span> <span
class="k">column</span> <span class="p">(</span><span
class="n">SUBSCRIBER_COUNT</span> <span class="nb">integer</span><span
class="p">);</span>
+<span class="k">alter</span> <span class="k">table</span> <span
class="n">BPEL_SELECTORS</span> <span class="k">add</span> <span
class="k">column</span> <span class="p">(</span><span
class="n">ROUTE_POLICY</span> <span class="nb">character</span> <span
class="nb">varying</span><span class="p">(</span><span
class="mi">255</span><span class="p">));</span>
+</pre></div>
+
+
+<h2 id="from-11-to-12">From 1.1 to 1.2</h2>
+<p>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 <em>backup before</em> to prevent any
data loss):</p>
+<div class="codehilite"><pre><span class="k">alter</span> <span
class="k">table</span> <span class="n">BPEL_SELECTORS</span> <span
class="k">add</span> <span class="k">column</span> <span
class="p">(</span><span class="n">PROC_TYPE</span> <span
class="nb">varchar</span><span class="p">(</span><span
class="mi">255</span><span class="p">));</span>
+<span class="k">update</span> <span class="n">BPEL_PROCESS</span> <span
class="n">p</span><span class="p">,</span> <span
class="n">BPEL_CORRELATOR</span> <span class="k">c</span><span
class="p">,</span> <span class="n">BPEL_SELECTORS</span> <span
class="n">s</span> <span class="k">set</span> <span class="n">s</span><span
class="p">.</span><span class="n">PROC_TYPE</span> <span class="o">=</span>
<span class="p">(</span><span class="s1">'{'</span> <span
class="o">+</span> <span class="n">p</span><span class="p">.</span><span
class="n">type_ns</span> <span class="o">+</span> <span
class="s1">'}'</span> <span class="o">+</span> <span
class="n">p</span><span class="p">.</span><span class="n">type_name</span><span
class="p">)</span> <span class="k">where</span> <span class="n">s</span><span
class="p">.</span><span class="n">CORRELATOR</span> <span class="o">=</span>
<span class="k">c</span><span class="p">.</span><span class="n">CID</span>
<span class="k">and</spa
n> <span class="k">c</span><span class="p">.</span><span
class="n">PROCESS_ID</span> <span class="o">=</span> <span
class="n">p</span><span class="p">.</span><span class="n">PROCID</span><span
class="p">;</span>
+</pre></div>
+
+
+<p>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:</p>
+<ul>
+<li>Redeploy your new ODE 1.2 WAR.</li>
+<li>Copy all the previous configuration and deployed processes (with the
corresponding markers).</li>
+</ul>
+<p>That's it!</p>
</div>
</div>
