[riftsaw-commits] riftsaw SVN: r917 - in branches/RiftSaw-2.1.x: distribution/src/main/release/db/jdbc and 2 other directories.

Author: jeff.yuchang Date: 2010-08-20 02:57:35 -0400 (Fri, 20 Aug 2010) New Revision: 917 Added: branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-db2-ds.xml branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/db2.properties branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/db2.drop.sql branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql Log: * RIFTSAW-269, Added db2 script. Added: branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-db2-ds.xml =================================================================== --- branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-db2-ds.xml (rev 0) +++ branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-db2-ds.xml 2010-08-20 06:57:35 UTC (rev 917) @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<datasources> + <local-tx-datasource> + <jndi-name>BPELDB</jndi-name> + <connection-url&gt;@connection.url(a)&lt;/connection-url&gt; + <driver-class>@driver@</driver-class> + <user-name>@username@</user-name> + <password>@password@</password> + + <metadata> + <type-mapping>DB2</type-mapping> + </metadata> + </local-tx-datasource> + +</datasources> \ No newline at end of file Added: branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/db2.properties =================================================================== --- branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/db2.properties (rev 0) +++ branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/db2.properties 2010-08-20 06:57:35 UTC (rev 917) @@ -0,0 +1,5 @@ +connection.url=jdbc:db2://localhost/riftsaw +driver=com.ibm.db2.jcc.DB2Driver +username=riftsaw +password=riftsaw +dialect=org.hibernate.dialect.DB2Dialect \ No newline at end of file Added: branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/db2.drop.sql =================================================================== --- branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/db2.drop.sql (rev 0) +++ branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/db2.drop.sql 2010-08-20 06:57:35 UTC (rev 917) @@ -0,0 +1,24 @@ +drop table ODE_SCHEMA_VERSION; +drop table ODE_JOB; + +drop table BPEL_ACTIVITY_RECOVERY; +drop table BPEL_CORRELATION_SET; +drop table BPEL_CORRELATOR; +drop table BPEL_CORSET_PROP; +drop table BPEL_EVENT; +drop table BPEL_FAULT; +drop table BPEL_MESSAGE; +drop table BPEL_MESSAGE_EXCHANGE; +drop table BPEL_MESSAGE_ROUTE; +drop table BPEL_MEX_PROP; +drop table BPEL_PARTNER_LINK; +drop table BPEL_PROCESS; +drop table BPEL_PROCESS_INSTANCE; +drop table BPEL_SCOPE; +drop table BPEL_XML_DATA; +drop table BPEL_XML_DATA_PROP; +drop table STORE_DU; +drop table STORE_PROCESS; +drop table STORE_PROCESS_PROP; +drop table STORE_PROC_TO_PROP; +drop table STORE_VERSIONS; \ No newline at end of file Added: branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql =================================================================== --- branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql (rev 0) +++ branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql 2010-08-20 06:57:35 UTC (rev 917) @@ -0,0 +1,245 @@ + +create table ODE_SCHEMA_VERSION(VERSION integer); +insert into ODE_SCHEMA_VERSION values (6); + +CREATE TABLE ODE_JOB ( + jobid CHAR(64) NOT NULL DEFAULT '', + ts BIGINT NOT NULL DEFAULT 0, + nodeid char(64), + scheduled int NOT NULL DEFAULT 0, + transacted int NOT NULL DEFAULT 0, + + instanceId BIGINT, + mexId varchar(255), + processId varchar(255), + type varchar(255), + channel varchar(255), + correlatorId varchar(255), + correlationKeySet varchar(255), + retryCount int, + inMem int, + detailsExt blob(1073741823) NULL, + + PRIMARY KEY(jobid)); + +CREATE INDEX IDX_ODE_JOB_TS ON ODE_JOB(ts); +CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid); + +create table BPEL_ACTIVITY_RECOVERY ( + ID bigint generated by default as identity, + ACTIONS varchar(255), + ACTIVITY_ID bigint, + CHANNEL varchar(255), + DATE_TIME timestamp, + DETAILS clob(255), + INSTANCE_ID bigint, + REASON varchar(255), + RETRIES integer, + primary key (ID) +); + +create table BPEL_CORRELATION_SET ( + CORRELATION_SET_ID bigint generated by default as identity, + CORRELATION_KEY varchar(255), + NAME varchar(255), + SCOPE_ID bigint, + primary key (CORRELATION_SET_ID) +); + +create table BPEL_CORRELATOR ( + CORRELATOR_ID bigint generated by default as identity, + CORRELATOR_KEY varchar(255), + PROC_ID bigint, + primary key (CORRELATOR_ID) +); + +create table BPEL_CORSET_PROP ( + ID bigint generated by default as identity, + CORRSET_ID bigint, + PROP_KEY varchar(255), + PROP_VALUE varchar(255), + primary key (ID) +); + +create table BPEL_EVENT ( + EVENT_ID bigint generated by default as identity, + DETAIL varchar(255), + DATA blob(255), + SCOPE_ID bigint, + TSTAMP timestamp, + TYPE varchar(255), + INSTANCE_ID bigint, + PROCESS_ID bigint, + primary key (EVENT_ID) +); + +create table BPEL_FAULT ( + FAULT_ID bigint generated by default as identity, + ACTIVITY_ID integer, + DATA clob(255), + MESSAGE varchar(4000), + LINE_NUMBER integer, + NAME varchar(255), + primary key (FAULT_ID) +); + +create table BPEL_MESSAGE ( + MESSAGE_ID bigint generated by default as identity, + DATA clob(255), + HEADER clob(255), + TYPE varchar(255), + MESSAGE_EXCHANGE_ID varchar(255), + primary key (MESSAGE_ID) +); + +create table BPEL_MESSAGE_EXCHANGE ( + MESSAGE_EXCHANGE_ID varchar(255) not null, + CALLEE varchar(255), + CHANNEL varchar(255), + CORRELATION_ID varchar(255), + CORRELATION_KEYS varchar(255), + CORRELATION_STATUS varchar(255), + CREATE_TIME timestamp, + DIRECTION char(1), + EPR clob(255), + FAULT varchar(255), + FAULT_EXPLANATION varchar(255), + OPERATION varchar(255), + PARTNER_LINK_MODEL_ID integer, + PATTERN varchar(255), + PIPED_ID varchar(255), + PORT_TYPE varchar(255), + PROPAGATE_TRANS smallint, + STATUS varchar(255), + SUBSCRIBER_COUNT integer, + CORR_ID bigint, + PARTNER_LINK_ID bigint, + PROCESS_ID bigint, + PROCESS_INSTANCE_ID bigint, + REQUEST_MESSAGE_ID bigint, + RESPONSE_MESSAGE_ID bigint, + primary key (MESSAGE_EXCHANGE_ID) +); + +create table BPEL_MESSAGE_ROUTE ( + MESSAGE_ROUTE_ID bigint generated by default as identity, + CORRELATION_KEY varchar(255), + GROUP_ID varchar(255), + ROUTE_INDEX integer, + PROCESS_INSTANCE_ID bigint, + ROUTE_POLICY varchar(16), + CORR_ID bigint, + primary key (MESSAGE_ROUTE_ID) +); + +create table BPEL_MEX_PROP ( + ID bigint generated by default as identity, + MEX_ID varchar(255), + PROP_KEY varchar(255), + PROP_VALUE varchar(2000), + primary key (ID) +); + +create table BPEL_PARTNER_LINK ( + PARTNER_LINK_ID bigint generated by default as identity, + MY_EPR clob(255), + MY_ROLE_NAME varchar(255), + MY_ROLE_SERVICE_NAME varchar(255), + MY_SESSION_ID varchar(255), + PARTNER_EPR clob(255), + PARTNER_LINK_MODEL_ID integer, + PARTNER_LINK_NAME varchar(255), + PARTNER_ROLE_NAME varchar(255), + PARTNER_SESSION_ID varchar(255), + SCOPE_ID bigint, + primary key (PARTNER_LINK_ID) +); + +create table BPEL_PROCESS ( + ID bigint generated by default as identity, + GUID varchar(255), + PROCESS_ID varchar(255), + PROCESS_TYPE varchar(255), + VERSION bigint, + primary key (ID) +); + +create table BPEL_PROCESS_INSTANCE ( + ID bigint generated by default as identity, + DATE_CREATED timestamp, + EXECUTION_STATE blob(255), + FAULT_ID bigint, + LAST_ACTIVE_TIME timestamp, + LAST_RECOVERY_DATE timestamp, + PREVIOUS_STATE smallint, + SEQUENCE bigint, + INSTANCE_STATE smallint, + INSTANTIATING_CORRELATOR_ID bigint, + PROCESS_ID bigint, + ROOT_SCOPE_ID bigint, + primary key (ID) +); + +create table BPEL_SCOPE ( + SCOPE_ID bigint generated by default as identity, + MODEL_ID integer, + SCOPE_NAME varchar(255), + SCOPE_STATE varchar(255), + PARENT_SCOPE_ID bigint, + PROCESS_INSTANCE_ID bigint, + primary key (SCOPE_ID) +); + +create table BPEL_XML_DATA ( + XML_DATA_ID bigint generated by default as identity, + DATA clob(255), + IS_SIMPLE_TYPE smallint, + NAME varchar(255), + SCOPE_ID bigint, + primary key (XML_DATA_ID) +); + +create table BPEL_XML_DATA_PROP ( + ID bigint generated by default as identity, + XML_DATA_ID bigint, + PROP_KEY varchar(255), + PROP_VALUE varchar(255), + primary key (ID) +); + +create table STORE_DU ( + NAME varchar(255) not null, + DEPLOYDT timestamp, + DEPLOYER varchar(255), + DIR varchar(255), + primary key (NAME) +); + +create table STORE_PROCESS ( + PID varchar(255) not null, + STATE varchar(255), + TYPE varchar(255), + VERSION bigint, + DU varchar(255), + primary key (PID) +); + +create table STORE_PROCESS_PROP ( + ID bigint generated by default as identity, + PROP_KEY varchar(255), + PROP_VAL varchar(255), + primary key (ID) +); + +create table STORE_PROC_TO_PROP ( + STORE_PROCESS_PID varchar(255) not null, + STORE_PROPERTY_ID bigint not null, + primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID), + unique (STORE_PROPERTY_ID) +); + +create table STORE_VERSIONS ( + ID bigint generated by default as identity, + VERSION bigint, + primary key (ID) +); \ No newline at end of file