Author: buildbot
Date: Fri Jul 14 09:21:34 2017
New Revision: 1015465
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 Fri Jul 14 09:21:34 2017
@@ -1 +1 @@
-1801918
+1801919
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 Fri Jul 14 09:21:34
2017
@@ -97,7 +97,18 @@
<div class="row">
<div class="span12">
- <h2 id="overview">Overview</h2>
+ <style type="text/css">
+/* The following code is added by mdx_elementid.py
+ It was originally lifted from http://subversion.apache.org/style/site.css */
+/*
+ * Hide class="elementid-permalink", except when an enclosing heading
+ * has the :hover property.
+ */
+.headerlink, .elementid-permalink {
+ visibility: hidden;
+}
+h2:hover > .headerlink, h3:hover > .headerlink, h1:hover > .headerlink,
h6:hover > .headerlink, h4:hover > .headerlink, h5:hover > .headerlink,
dt:hover > .elementid-permalink { visibility: visible }</style>
+<h2 id="overview">Overview<a class="headerlink" href="#overview"
title="Permanent link">¶</a></h2>
<div class="alert alert-note"><h4 class="alert-heading">You shall
backup</h4></div>
<p>ODE upgrade procedures usually consist in:</p>
@@ -109,7 +120,11 @@
<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>
+<h2 id="from-ode-136-137">From ODE 1.3.6 - 1.3.7<a class="headerlink"
href="#from-ode-136-137" title="Permanent link">¶</a></h2>
+<p>Migration is necessary from 1.3.6, read the migration script available <a
href="https://github.com/apache/ode/blob/APACHE_ODE_1.3.7/schema-updates/migrate-ode-1.3.6-to-1.3.7.sql";>here</a>.</p>
+<h2 id="from-ode-134-136">From ODE 1.3.4 - 1.3.6<a class="headerlink"
href="#from-ode-134-136" title="Permanent link">¶</a></h2>
+<p>ODE 1.3.4, 1.3.5 and 1.3.6 share the same schema definitions.</p>
+<h2 id="from-133-to-134">From 1.3.3 to 1.3.4<a class="headerlink"
href="#from-133-to-134" title="Permanent link">¶</a></h2>
<p>First, apply SQLs to denormalize LARGE_DATA table from <a
href="https://issues.apache.org/jira/browse/ODE-694";>here</a></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>
@@ -131,11 +146,11 @@
</pre></div>
-<h2 id="from-132-to-133">From 1.3.2 to 1.3.3</h2>
+<h2 id="from-132-to-133">From 1.3.2 to 1.3.3<a class="headerlink"
href="#from-132-to-133" title="Permanent link">¶</a></h2>
<p>None</p>
-<h2 id="from-12-to-132">From 1.2 to 1.3.2</h2>
+<h2 id="from-12-to-132">From 1.2 to 1.3.2<a class="headerlink"
href="#from-12-to-132" title="Permanent link">¶</a></h2>
<p>If you're currently using ODE 1.2 and are upgrading to 1.3.2, please run
the following queries.</p>
-<h3 id="for-openjpa-database-schema">For OpenJPA database schema</h3>
+<h3 id="for-openjpa-database-schema">For OpenJPA database schema<a
class="headerlink" href="#for-openjpa-database-schema" title="Permanent
link">¶</a></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>
@@ -144,7 +159,7 @@
</pre></div>
-<h3 id="for-hibernate-database-schema">For Hibernate database schema</h3>
+<h3 id="for-hibernate-database-schema">For Hibernate database schema<a
class="headerlink" href="#for-hibernate-database-schema" title="Permanent
link">¶</a></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>
@@ -154,7 +169,7 @@
</pre></div>
-<h2 id="from-11-to-12">From 1.1 to 1.2</h2>
+<h2 id="from-11-to-12">From 1.1 to 1.2<a class="headerlink"
href="#from-11-to-12" title="Permanent link">¶</a></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</span> <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>
