[
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)
