Author: jeff.yuchang Date: 2010-10-01 05:43:40 -0400 (Fri, 01 Oct 2010) New Revision: 1005 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql Log: * update data type for db2 clob. Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql 2010-10-01 05:15:44 UTC (rev 1004) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql 2010-10-01 09:43:40 UTC (rev 1005) @@ -31,7 +31,7 @@ ACTIVITY_ID bigint, CHANNEL varchar(255), DATE_TIME timestamp, - DETAILS clob(255), + DETAILS clob(1M), INSTANCE_ID bigint, REASON varchar(255), RETRIES integer, @@ -76,7 +76,7 @@ create table BPEL_FAULT ( FAULT_ID bigint generated by default as identity, ACTIVITY_ID integer, - DATA clob(255), + DATA clob(1M), MESSAGE varchar(4000), LINE_NUMBER integer, NAME varchar(255), @@ -85,8 +85,8 @@ create table BPEL_MESSAGE ( MESSAGE_ID bigint generated by default as identity, - DATA clob(255), - HEADER clob(255), + DATA clob(1M), + HEADER clob(1M), TYPE varchar(255), MESSAGE_EXCHANGE_ID varchar(255), primary key (MESSAGE_ID) @@ -101,7 +101,7 @@ CORRELATION_STATUS varchar(255), CREATE_TIME timestamp, DIRECTION char(1), - EPR clob(255), + EPR clob(1M), FAULT varchar(255), FAULT_EXPLANATION varchar(255), OPERATION varchar(255), @@ -142,11 +142,11 @@ create table BPEL_PARTNER_LINK ( PARTNER_LINK_ID bigint generated by default as identity, - MY_EPR clob(255), + MY_EPR clob(1M), MY_ROLE_NAME varchar(255), MY_ROLE_SERVICE_NAME varchar(255), MY_SESSION_ID varchar(255), - PARTNER_EPR clob(255), + PARTNER_EPR clob(1M), PARTNER_LINK_MODEL_ID integer, PARTNER_LINK_NAME varchar(255), PARTNER_ROLE_NAME varchar(255), @@ -192,7 +192,7 @@ create table BPEL_XML_DATA ( XML_DATA_ID bigint generated by default as identity, - DATA clob(255), + DATA clob(1M), IS_SIMPLE_TYPE smallint, NAME varchar(255), SCOPE_ID bigint,