ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sathwik Bantwal Premakumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ODE-1051) Database migration from ODE 1.3.6 to 1.3.7
Date Fri, 04 Nov 2016 05:22:58 GMT

    [ https://issues.apache.org/jira/browse/ODE-1051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15635292#comment-15635292
] 

Sathwik Bantwal Premakumar commented on ODE-1051:
-------------------------------------------------

The migration as described in ticket ODE-1035 is required for all databases.

Below migration is required for MYSQL for Hibernate only, in addition to migration described
in ODE-1035.

||Table Name||Column Name||OLD Datatype|| NEW Datatype||
|BPEL_ACTIVITY_RECOVERY|DETAILS| blob| longblob|
|BPEL_EVENT|DETAIL|text|longtext|
|BPEL_EVENT|DATA|blob|longblob|
|BPEL_FAULT|DATA|blob|longblob|
|BPEL_INSTANCE|JACOB_STATE_DATA|blob|longblob|
|BPEL_MESSAGE|MESSAGE_DATA|blob|longblob
|BPEL_MESSAGE|MESSAGE_HEADER|blob|longblob|
|BPEL_MESSAGE_EXCHANGE|ENDPOINT|blob|longblob|
|BPEL_MESSAGE_EXCHANGE|CALLBACK_ENDPOINT|blob|longblob|
|BPEL_PLINK_VAL|MYROLE_EPR_DATA|blob|longblob|
|BPEL_PLINK_VAL|PARTNERROLE_EPR_DATA|blob|longblob|

{panel:title=MYSQL migration script for Hibernate|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1|bgColor=#FFFFCE}
ALTER TABLE BPEL_ACTIVITY_RECOVERY  MODIFY DETAILS              longblob;
ALTER TABLE BPEL_EVENT              MODIFY DETAIL               longtext;
ALTER TABLE BPEL_EVENT              MODIFY DATA                 longblob;
ALTER TABLE BPEL_FAULT              MODIFY DATA                 longblob;
ALTER TABLE BPEL_INSTANCE           MODIFY JACOB_STATE_DATA     longblob;
ALTER TABLE BPEL_MESSAGE            MODIFY MESSAGE_DATA         longblob;
ALTER TABLE BPEL_MESSAGE            MODIFY MESSAGE_HEADER       longblob;
ALTER TABLE BPEL_MESSAGE_EXCHANGE   MODIFY ENDPOINT             longblob;
ALTER TABLE BPEL_MESSAGE_EXCHANGE   MODIFY CALLBACK_ENDPOINT    longblob;
ALTER TABLE BPEL_PLINK_VAL          MODIFY MYROLE_EPR_DATA      longblob;
ALTER TABLE BPEL_PLINK_VAL          MODIFY PARTNERROLE_EPR_DATA longblob;
ALTER TABLE BPEL_XML_DATA           MODIFY DATA                 longblob;
{panel}

> Database migration from ODE 1.3.6 to 1.3.7
> ------------------------------------------
>
>                 Key: ODE-1051
>                 URL: https://issues.apache.org/jira/browse/ODE-1051
>             Project: ODE
>          Issue Type: Bug
>          Components: BPEL Runtime, Build System
>    Affects Versions: 1.3.6
>            Reporter: Sathwik Bantwal Premakumar
>            Assignee: Sathwik Bantwal Premakumar
>             Fix For: 1.3.7
>
>
> This is an umbrella ticket to keep track of all database migrations required for upgrading
to ODE 1.3.7 from 1.3.6 and below versions.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message