riftsaw SVN: r1063 - branches/RiftSaw-2.1.x/distribution/src/main/release/install.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-27 02:02:19 -0400 (Wed, 27 Oct 2010)
New Revision: 1063
Modified:
branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml
Log:
* RIFTSAW-207,RIFTSAW-308: update the juddi.
Modified: branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml
===================================================================
--- branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml 2010-10-27 05:59:49 UTC (rev 1062)
+++ branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml 2010-10-27 06:02:19 UTC (rev 1063)
@@ -257,8 +257,8 @@
value="bpel.uddi.client.impl=org.jboss.soa.bpel.uddi.UDDIRegistration"/>
<!-- juddi-client, should be removed once esb catches up to 3.0.4-->
- <!-- now deletes the 3.0.1 version, and then copy the 3.0.4 into the esb.deployer/lib-->
- <delete file="${deployers.dir}/esb.deployer/lib/juddi-client-3.0.1.jar" />
+ <!-- now deletes the 3.0.3 version, and then copy the 3.0.4 into the esb.deployer/lib-->
+ <delete file="${deployers.dir}/esb.deployer/lib/juddi-client-3.0.3.jar" />
<copy todir="${deployers.dir}/esb.deployer/lib" overwrite="true">
<fileset dir="../db/juddi">
<include name="juddi-client-*.jar"/>
13 years, 8 months
riftsaw SVN: r1062 - in branches/RiftSaw-2.1.x: distribution/src/main/release/install and 4 other directories.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-27 01:59:49 -0400 (Wed, 27 Oct 2010)
New Revision: 1062
Modified:
branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml
branches/RiftSaw-2.1.x/docs/docbook/gettingstartedguide/src/main/module/installation.xml
branches/RiftSaw-2.1.x/integration-tests/pom.xml
branches/RiftSaw-2.1.x/pom.xml
branches/RiftSaw-2.1.x/qa/hudson-riftsaw-db.sh
branches/RiftSaw-2.1.x/qa/hudson-riftsaw-jboss.sh
branches/RiftSaw-2.1.x/qa/hudson-riftsaw-local.sh
branches/RiftSaw-2.1.x/qa/hudson-riftsaw-soa-p.sh
branches/RiftSaw-2.1.x/qa/hudson-riftsaw-ws.sh
branches/RiftSaw-2.1.x/runtime/jbossesb-bpel/pom.xml
Log:
* RIFTSAW-307, RIFTSAW-308: upgrade ESB to 4.9
Modified: branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml
===================================================================
--- branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/distribution/src/main/release/install/build.xml 2010-10-27 05:59:49 UTC (rev 1062)
@@ -129,9 +129,6 @@
<!-- install database specific driver -->
<target name="internal.install.riftsaw.into.jboss.db.hsql">
- <!-- If the older version of h2 exists, as installed by the ESB (4.7), then rename it -->
- <move file="${server.lib.dir}/h2-1.0.68.jar" tofile="${server.lib.dir}/h2-1.0.68.jar.OLD"
- failonerror="no" />
<copy todir="${server.lib.dir}" overwrite="true">
<fileset dir="../db/drivers">
Modified: branches/RiftSaw-2.1.x/docs/docbook/gettingstartedguide/src/main/module/installation.xml
===================================================================
--- branches/RiftSaw-2.1.x/docs/docbook/gettingstartedguide/src/main/module/installation.xml 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/docs/docbook/gettingstartedguide/src/main/module/installation.xml 2010-10-27 05:59:49 UTC (rev 1062)
@@ -24,7 +24,7 @@
<listitem>JBossAS (version 5.1.0.GA or higher) <emphasis role="bold">jdk6</emphasis> version, available from
<ulink url="http://www.jboss.org/jbossas">http://www.jboss.org/jbossas</ulink>, and please upgrade the web
service stack to version 3.2.2.GA, as described in the following 'Upgrade web service for JBoss AS' section.</listitem>
- <listitem>JBossESB (version 4.8.GA or higher), should download the <emphasis role="bold">jbossesb-4.8.GA.zip</emphasis>,
+ <listitem>JBossESB (version 4.9 or higher), should download the <emphasis role="bold">jbossesb-4.8.GA.zip</emphasis>,
available from <ulink url="http://www.jboss.org/jbossesb">http://www.jboss.org/jbossesb</ulink>.
This is only required to run the ESB/BPEL examples.</listitem>
<listitem>RiftSaw, available from
Modified: branches/RiftSaw-2.1.x/integration-tests/pom.xml
===================================================================
--- branches/RiftSaw-2.1.x/integration-tests/pom.xml 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/integration-tests/pom.xml 2010-10-27 05:59:49 UTC (rev 1062)
@@ -49,9 +49,9 @@
<scope>test</scope>
</dependency>
<dependency>
- <groupId>org.jboss.soa.bpel.dependencies.esb</groupId>
+ <groupId>jboss.jbossts</groupId>
<artifactId>jbossts-common</artifactId>
- <version>${jbossesb.version}</version>
+ <version>${jbossts.version}</version>
<scope>test</scope>
</dependency>
<dependency>
Modified: branches/RiftSaw-2.1.x/pom.xml
===================================================================
--- branches/RiftSaw-2.1.x/pom.xml 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/pom.xml 2010-10-27 05:59:49 UTC (rev 1062)
@@ -79,7 +79,8 @@
<junit.version>3.8.1</junit.version>
<jboss.version>5.1.0.GA</jboss.version>
<log4j.version>1.2.14</log4j.version>
- <jbossesb.version>4.8</jbossesb.version>
+ <jbossesb.version>4.9</jbossesb.version>
+ <jbossts.version>4.6.1.GA</jbossts.version>
<wsdl4j.version>1.6.2</wsdl4j.version>
<h2.version>1.2.124</h2.version>
<javassist.version>3.11.0.GA</javassist.version>
@@ -282,26 +283,26 @@
<version>${commons.httpclient.version}</version>
</dependency>
- <dependency>
- <groupId>net.sf.saxon</groupId>
- <artifactId>saxon-dom</artifactId>
- <version>${saxon.version}</version>
- </dependency>
- <dependency>
- <groupId>net.sf.saxon</groupId>
- <artifactId>saxon-xpath</artifactId>
- <version>${saxon.version}</version>
- </dependency>
- <dependency>
- <groupId>net.sf.saxon</groupId>
- <artifactId>saxon-xqj</artifactId>
- <version>${saxon.version}</version>
- </dependency>
- <dependency>
- <groupId>net.sf.saxon</groupId>
- <artifactId>saxon</artifactId>
- <version>${saxon.version}</version>
+ <dependency>
+ <groupId>net.sf.saxon</groupId>
+ <artifactId>saxon-dom</artifactId>
+ <version>${saxon.version}</version>
</dependency>
+ <dependency>
+ <groupId>net.sf.saxon</groupId>
+ <artifactId>saxon-xpath</artifactId>
+ <version>${saxon.version}</version>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.saxon</groupId>
+ <artifactId>saxon-xqj</artifactId>
+ <version>${saxon.version}</version>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.saxon</groupId>
+ <artifactId>saxon</artifactId>
+ <version>${saxon.version}</version>
+ </dependency>
</dependencies>
</dependencyManagement>
Modified: branches/RiftSaw-2.1.x/qa/hudson-riftsaw-db.sh
===================================================================
--- branches/RiftSaw-2.1.x/qa/hudson-riftsaw-db.sh 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/qa/hudson-riftsaw-db.sh 2010-10-27 05:59:49 UTC (rev 1062)
@@ -13,7 +13,7 @@
AS_CONFIG="default"
REPLACE_QA_JDBC="true"
-JBOSS_ESB_VERSION="4.8"
+JBOSS_ESB_VERSION="4.9"
JBOSS_ESB_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jbossesb-$JBOSS_ESB_VERSION"
WS_VERSION="3.2.2.GA"
Modified: branches/RiftSaw-2.1.x/qa/hudson-riftsaw-jboss.sh
===================================================================
--- branches/RiftSaw-2.1.x/qa/hudson-riftsaw-jboss.sh 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/qa/hudson-riftsaw-jboss.sh 2010-10-27 05:59:49 UTC (rev 1062)
@@ -12,7 +12,7 @@
AS_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jboss-$JBOSS_VERSION"
AS_CONFIG="default"
REPLACE_QA_JDBC="true"
-JBOSS_ESB_VERSION="4.8"
+JBOSS_ESB_VERSION="4.9"
JBOSS_ESB_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jbossesb-$JBOSS_ESB_VERSION"
STARTUP_TIME="6"
Modified: branches/RiftSaw-2.1.x/qa/hudson-riftsaw-local.sh
===================================================================
--- branches/RiftSaw-2.1.x/qa/hudson-riftsaw-local.sh 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/qa/hudson-riftsaw-local.sh 2010-10-27 05:59:49 UTC (rev 1062)
@@ -12,7 +12,7 @@
AS_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jboss-$JBOSS_VERSION"
AS_CONFIG="default"
REPLACE_QA_JDBC="true"
-JBOSS_ESB_VERSION="4.8"
+JBOSS_ESB_VERSION="4.9"
JBOSS_ESB_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jbossesb-$JBOSS_ESB_VERSION"
DATABASE="db2"
Modified: branches/RiftSaw-2.1.x/qa/hudson-riftsaw-soa-p.sh
===================================================================
--- branches/RiftSaw-2.1.x/qa/hudson-riftsaw-soa-p.sh 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/qa/hudson-riftsaw-soa-p.sh 2010-10-27 05:59:49 UTC (rev 1062)
@@ -14,7 +14,7 @@
AS_CONFIG="default"
REPLACE_QA_JDBC="true"
-JBOSS_ESB_VERSION="4.8"
+JBOSS_ESB_VERSION="4.9"
JBOSS_ESB_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jbossesb-$JBOSS_ESB_VERSION"
WS_VERSION="3.2.2.GA"
Modified: branches/RiftSaw-2.1.x/qa/hudson-riftsaw-ws.sh
===================================================================
--- branches/RiftSaw-2.1.x/qa/hudson-riftsaw-ws.sh 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/qa/hudson-riftsaw-ws.sh 2010-10-27 05:59:49 UTC (rev 1062)
@@ -14,7 +14,7 @@
WS_STACK_DIR="$RIFTSAW_PARENT_DIR/downloads"
REPLACE_QA_JDBC="true"
-JBOSS_ESB_VERSION="4.8"
+JBOSS_ESB_VERSION="4.9"
JBOSS_ESB_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jbossesb-$JBOSS_ESB_VERSION"
WS_VERSION="3.2.2.GA"
Modified: branches/RiftSaw-2.1.x/runtime/jbossesb-bpel/pom.xml
===================================================================
--- branches/RiftSaw-2.1.x/runtime/jbossesb-bpel/pom.xml 2010-10-26 01:09:22 UTC (rev 1061)
+++ branches/RiftSaw-2.1.x/runtime/jbossesb-bpel/pom.xml 2010-10-27 05:59:49 UTC (rev 1062)
@@ -26,9 +26,9 @@
<scope>provided</scope>
</dependency>
<dependency>
- <groupId>org.jboss.soa.bpel.dependencies.esb</groupId>
+ <groupId>jboss.jbossts</groupId>
<artifactId>jbossts-common</artifactId>
- <version>${jbossesb.version}</version>
+ <version>${jbossts.version}</version>
<scope>test</scope>
</dependency>
<dependency>
13 years, 8 months
riftsaw SVN: r1061 - trunk/runtime/engine-assembly/src/main/resources/bpel-sql.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-25 21:09:22 -0400 (Mon, 25 Oct 2010)
New Revision: 1061
Modified:
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
Log:
* RIFTSAW-306, applied Julian's fix.
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-26 01:06:41 UTC (rev 1060)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-26 01:09:22 UTC (rev 1061)
@@ -2,11 +2,11 @@
insert into ODE_SCHEMA_VERSION values (6);
CREATE TABLE ODE_JOB (
- jobid CHAR(64) NOT NULL DEFAULT '',
- ts BIGINT NOT NULL DEFAULT 0,
+ jobid CHAR(64) DEFAULT '' NOT NULL,
+ ts BIGINT DEFAULT 0 NOT NULL,
nodeid char(64),
- scheduled int NOT NULL DEFAULT 0,
- transacted int NOT NULL DEFAULT 0,
+ scheduled int DEFAULT 0 NOT NULL,
+ transacted int DEFAULT 0 NOT NULL,
instanceId BIGINT,
mexId varchar(255),
13 years, 8 months
riftsaw SVN: r1060 - branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-25 21:06:41 -0400 (Mon, 25 Oct 2010)
New Revision: 1060
Modified:
branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
Log:
* RIFTSAW-306, applied Julian's fix.
Modified: branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
===================================================================
--- branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-25 04:08:24 UTC (rev 1059)
+++ branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-26 01:06:41 UTC (rev 1060)
@@ -2,11 +2,11 @@
insert into ODE_SCHEMA_VERSION values (6);
CREATE TABLE ODE_JOB (
- jobid CHAR(64) NOT NULL DEFAULT '',
- ts BIGINT NOT NULL DEFAULT 0,
+ jobid CHAR(64) DEFAULT '' NOT NULL,
+ ts BIGINT DEFAULT 0 NOT NULL,
nodeid char(64),
- scheduled int NOT NULL DEFAULT 0,
- transacted int NOT NULL DEFAULT 0,
+ scheduled int DEFAULT 0 NOT NULL,
+ transacted int DEFAULT 0 NOT NULL,
instanceId BIGINT,
mexId varchar(255),
13 years, 8 months
riftsaw SVN: r1059 - in trunk: distribution/src/main/release/db/jdbc and 2 other directories.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-25 00:08:24 -0400 (Mon, 25 Oct 2010)
New Revision: 1059
Added:
trunk/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml
trunk/distribution/src/main/release/db/jdbc/sybase.properties
trunk/distribution/src/main/release/db/sql/sybase.drop.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
Log:
* RIFTSAW-306, sybase support.
Added: trunk/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml
===================================================================
--- trunk/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml (rev 0)
+++ trunk/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml 2010-10-25 04:08:24 UTC (rev 1059)
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<datasources>
+ <local-tx-datasource>
+ <jndi-name>BPELDB</jndi-name>
+ <connection-url>@connection.url@</connection-url>
+ <driver-class>@driver@</driver-class>
+ <user-name>@username@</user-name>
+ <password>@password@</password>
+
+ <metadata>
+ <type-mapping>Sybase</type-mapping>
+ </metadata>
+ </local-tx-datasource>
+
+</datasources>
\ No newline at end of file
Added: trunk/distribution/src/main/release/db/jdbc/sybase.properties
===================================================================
--- trunk/distribution/src/main/release/db/jdbc/sybase.properties (rev 0)
+++ trunk/distribution/src/main/release/db/jdbc/sybase.properties 2010-10-25 04:08:24 UTC (rev 1059)
@@ -0,0 +1,5 @@
+connection.url=jdbc:sybase:Tds:localhost:5000/riftsaw
+driver=com.sybase.jdbc2.jdbc.SybDataSource
+username=riftsaw
+password=riftsaw
+dialect=org.hibernate.dialect.SybaseDialect
\ No newline at end of file
Added: trunk/distribution/src/main/release/db/sql/sybase.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/sybase.drop.sql (rev 0)
+++ trunk/distribution/src/main/release/db/sql/sybase.drop.sql 2010-10-25 04:08:24 UTC (rev 1059)
@@ -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: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql (rev 0)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-25 04:08:24 UTC (rev 1059)
@@ -0,0 +1,244 @@
+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 IMAGE 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 numeric(19,0) identity not null,
+ ACTIONS varchar(255) null,
+ ACTIVITY_ID numeric(19,0) null,
+ CHANNEL varchar(255) null,
+ DATE_TIME datetime null,
+ DETAILS text null,
+ INSTANCE_ID numeric(19,0) null,
+ REASON varchar(255) null,
+ RETRIES int null,
+ primary key (ID)
+);
+
+create table BPEL_CORRELATION_SET (
+ CORRELATION_SET_ID numeric(19,0) identity not null,
+ CORRELATION_KEY varchar(255) null,
+ NAME varchar(255) null,
+ SCOPE_ID numeric(19,0) null,
+ primary key (CORRELATION_SET_ID)
+);
+
+create table BPEL_CORRELATOR (
+ CORRELATOR_ID numeric(19,0) identity not null,
+ CORRELATOR_KEY varchar(255) null,
+ PROC_ID numeric(19,0) null,
+ primary key (CORRELATOR_ID)
+);
+
+create table BPEL_CORSET_PROP (
+ ID numeric(19,0) identity not null,
+ CORRSET_ID numeric(19,0) null,
+ PROP_KEY varchar(255) null,
+ PROP_VALUE varchar(255) null,
+ primary key (ID)
+);
+
+create table BPEL_EVENT (
+ EVENT_ID numeric(19,0) identity not null,
+ DETAIL varchar(255) null,
+ DATA image null,
+ SCOPE_ID numeric(19,0) null,
+ TSTAMP datetime null,
+ TYPE varchar(255) null,
+ INSTANCE_ID numeric(19,0) null,
+ PROCESS_ID numeric(19,0) null,
+ primary key (EVENT_ID)
+);
+
+create table BPEL_FAULT (
+ FAULT_ID numeric(19,0) identity not null,
+ ACTIVITY_ID int null,
+ DATA text null,
+ MESSAGE varchar(4000) null,
+ LINE_NUMBER int null,
+ NAME varchar(255) null,
+ primary key (FAULT_ID)
+);
+
+create table BPEL_MESSAGE (
+ MESSAGE_ID numeric(19,0) identity not null,
+ DATA text null,
+ HEADER text null,
+ TYPE varchar(255) null,
+ MESSAGE_EXCHANGE_ID varchar(255) null,
+ primary key (MESSAGE_ID)
+);
+
+create table BPEL_MESSAGE_EXCHANGE (
+ MESSAGE_EXCHANGE_ID varchar(255) not null,
+ CALLEE varchar(255) null,
+ CHANNEL varchar(255) null,
+ CORRELATION_ID varchar(255) null,
+ CORRELATION_KEYS varchar(255) null,
+ CORRELATION_STATUS varchar(255) null,
+ CREATE_TIME datetime null,
+ DIRECTION char(1) null,
+ EPR text null,
+ FAULT varchar(255) null,
+ FAULT_EXPLANATION varchar(255) null,
+ OPERATION varchar(255) null,
+ PARTNER_LINK_MODEL_ID int null,
+ PATTERN varchar(255) null,
+ PIPED_ID varchar(255) null,
+ PORT_TYPE varchar(255) null,
+ PROPAGATE_TRANS tinyint null,
+ STATUS varchar(255) null,
+ SUBSCRIBER_COUNT int null,
+ CORR_ID numeric(19,0) null,
+ PARTNER_LINK_ID numeric(19,0) null,
+ PROCESS_ID numeric(19,0) null,
+ PROCESS_INSTANCE_ID numeric(19,0) null,
+ REQUEST_MESSAGE_ID numeric(19,0) null,
+ RESPONSE_MESSAGE_ID numeric(19,0) null,
+ primary key (MESSAGE_EXCHANGE_ID)
+);
+
+create table BPEL_MESSAGE_ROUTE (
+ MESSAGE_ROUTE_ID numeric(19,0) identity not null,
+ CORRELATION_KEY varchar(255) null,
+ GROUP_ID varchar(255) null,
+ ROUTE_INDEX int null,
+ PROCESS_INSTANCE_ID numeric(19,0) null,
+ ROUTE_POLICY varchar(16) null,
+ CORR_ID numeric(19,0) null,
+ primary key (MESSAGE_ROUTE_ID)
+);
+
+create table BPEL_MEX_PROP (
+ ID numeric(19,0) identity not null,
+ MEX_ID varchar(255) null,
+ PROP_KEY varchar(255) null,
+ PROP_VALUE varchar(2000) null,
+ primary key (ID)
+);
+
+create table BPEL_PARTNER_LINK (
+ PARTNER_LINK_ID numeric(19,0) identity not null,
+ MY_EPR text null,
+ MY_ROLE_NAME varchar(255) null,
+ MY_ROLE_SERVICE_NAME varchar(255) null,
+ MY_SESSION_ID varchar(255) null,
+ PARTNER_EPR text null,
+ PARTNER_LINK_MODEL_ID int null,
+ PARTNER_LINK_NAME varchar(255) null,
+ PARTNER_ROLE_NAME varchar(255) null,
+ PARTNER_SESSION_ID varchar(255) null,
+ SCOPE_ID numeric(19,0) null,
+ primary key (PARTNER_LINK_ID)
+);
+
+create table BPEL_PROCESS (
+ ID numeric(19,0) identity not null,
+ GUID varchar(255) null,
+ PROCESS_ID varchar(255) null,
+ PROCESS_TYPE varchar(255) null,
+ VERSION numeric(19,0) null,
+ primary key (ID)
+);
+
+create table BPEL_PROCESS_INSTANCE (
+ ID numeric(19,0) identity not null,
+ DATE_CREATED datetime null,
+ EXECUTION_STATE image null,
+ FAULT_ID numeric(19,0) null,
+ LAST_ACTIVE_TIME datetime null,
+ LAST_RECOVERY_DATE datetime null,
+ PREVIOUS_STATE smallint null,
+ SEQUENCE numeric(19,0) null,
+ INSTANCE_STATE smallint null,
+ INSTANTIATING_CORRELATOR_ID numeric(19,0) null,
+ PROCESS_ID numeric(19,0) null,
+ ROOT_SCOPE_ID numeric(19,0) null,
+ primary key (ID)
+);
+
+create table BPEL_SCOPE (
+ SCOPE_ID numeric(19,0) identity not null,
+ MODEL_ID int null,
+ SCOPE_NAME varchar(255) null,
+ SCOPE_STATE varchar(255) null,
+ PARENT_SCOPE_ID numeric(19,0) null,
+ PROCESS_INSTANCE_ID numeric(19,0) null,
+ primary key (SCOPE_ID)
+);
+
+create table BPEL_XML_DATA (
+ XML_DATA_ID numeric(19,0) identity not null,
+ DATA text null,
+ IS_SIMPLE_TYPE tinyint null,
+ NAME varchar(255) null,
+ SCOPE_ID numeric(19,0) null,
+ primary key (XML_DATA_ID)
+);
+
+create table BPEL_XML_DATA_PROP (
+ ID numeric(19,0) identity not null,
+ XML_DATA_ID numeric(19,0) null,
+ PROP_KEY varchar(255) null,
+ PROP_VALUE varchar(255) null,
+ primary key (ID)
+);
+
+create table STORE_DU (
+ NAME varchar(255) not null,
+ DEPLOYDT datetime null,
+ DEPLOYER varchar(255) null,
+ DIR varchar(255) null,
+ primary key (NAME)
+);
+
+create table STORE_PROCESS (
+ PID varchar(255) not null,
+ STATE varchar(255) null,
+ TYPE varchar(255) null,
+ VERSION numeric(19,0) null,
+ DU varchar(255) null,
+ primary key (PID)
+);
+
+create table STORE_PROCESS_PROP (
+ ID numeric(19,0) identity not null,
+ PROP_KEY varchar(255) null,
+ PROP_VAL varchar(255) null,
+ primary key (ID)
+);
+
+create table STORE_PROC_TO_PROP (
+ STORE_PROCESS_PID varchar(255) not null,
+ STORE_PROPERTY_ID numeric(19,0) not null,
+ primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID),
+ unique (STORE_PROPERTY_ID)
+);
+
+create table STORE_VERSIONS (
+ ID numeric(19,0) identity not null,
+ VERSION numeric(19,0) null,
+ primary key (ID)
+);
\ No newline at end of file
13 years, 8 months
riftsaw SVN: r1058 - in branches/RiftSaw-2.1.x: distribution/src/main/release/db/jdbc and 2 other directories.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-24 23:55:14 -0400 (Sun, 24 Oct 2010)
New Revision: 1058
Added:
branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml
branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/sybase.properties
branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/sybase.drop.sql
branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
Log:
* RIFTSAW-306, sybase db support.
Added: branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml
===================================================================
--- branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml (rev 0)
+++ branches/RiftSaw-2.1.x/distribution/src/main/release/db/datasource/bpel-sybase-ds.xml 2010-10-25 03:55:14 UTC (rev 1058)
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<datasources>
+ <local-tx-datasource>
+ <jndi-name>BPELDB</jndi-name>
+ <connection-url>@connection.url@</connection-url>
+ <driver-class>@driver@</driver-class>
+ <user-name>@username@</user-name>
+ <password>@password@</password>
+
+ <metadata>
+ <type-mapping>Sybase</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/sybase.properties
===================================================================
--- branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/sybase.properties (rev 0)
+++ branches/RiftSaw-2.1.x/distribution/src/main/release/db/jdbc/sybase.properties 2010-10-25 03:55:14 UTC (rev 1058)
@@ -0,0 +1,5 @@
+connection.url=jdbc:sybase:Tds:localhost:5000/riftsaw
+driver=com.sybase.jdbc2.jdbc.SybDataSource
+username=riftsaw
+password=riftsaw
+dialect=org.hibernate.dialect.SybaseDialect
\ No newline at end of file
Added: branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/sybase.drop.sql
===================================================================
--- branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/sybase.drop.sql (rev 0)
+++ branches/RiftSaw-2.1.x/distribution/src/main/release/db/sql/sybase.drop.sql 2010-10-25 03:55:14 UTC (rev 1058)
@@ -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/sybase.sql
===================================================================
--- branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql (rev 0)
+++ branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-25 03:55:14 UTC (rev 1058)
@@ -0,0 +1,244 @@
+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 IMAGE 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 numeric(19,0) identity not null,
+ ACTIONS varchar(255) null,
+ ACTIVITY_ID numeric(19,0) null,
+ CHANNEL varchar(255) null,
+ DATE_TIME datetime null,
+ DETAILS text null,
+ INSTANCE_ID numeric(19,0) null,
+ REASON varchar(255) null,
+ RETRIES int null,
+ primary key (ID)
+);
+
+create table BPEL_CORRELATION_SET (
+ CORRELATION_SET_ID numeric(19,0) identity not null,
+ CORRELATION_KEY varchar(255) null,
+ NAME varchar(255) null,
+ SCOPE_ID numeric(19,0) null,
+ primary key (CORRELATION_SET_ID)
+);
+
+create table BPEL_CORRELATOR (
+ CORRELATOR_ID numeric(19,0) identity not null,
+ CORRELATOR_KEY varchar(255) null,
+ PROC_ID numeric(19,0) null,
+ primary key (CORRELATOR_ID)
+);
+
+create table BPEL_CORSET_PROP (
+ ID numeric(19,0) identity not null,
+ CORRSET_ID numeric(19,0) null,
+ PROP_KEY varchar(255) null,
+ PROP_VALUE varchar(255) null,
+ primary key (ID)
+);
+
+create table BPEL_EVENT (
+ EVENT_ID numeric(19,0) identity not null,
+ DETAIL varchar(255) null,
+ DATA image null,
+ SCOPE_ID numeric(19,0) null,
+ TSTAMP datetime null,
+ TYPE varchar(255) null,
+ INSTANCE_ID numeric(19,0) null,
+ PROCESS_ID numeric(19,0) null,
+ primary key (EVENT_ID)
+);
+
+create table BPEL_FAULT (
+ FAULT_ID numeric(19,0) identity not null,
+ ACTIVITY_ID int null,
+ DATA text null,
+ MESSAGE varchar(4000) null,
+ LINE_NUMBER int null,
+ NAME varchar(255) null,
+ primary key (FAULT_ID)
+);
+
+create table BPEL_MESSAGE (
+ MESSAGE_ID numeric(19,0) identity not null,
+ DATA text null,
+ HEADER text null,
+ TYPE varchar(255) null,
+ MESSAGE_EXCHANGE_ID varchar(255) null,
+ primary key (MESSAGE_ID)
+);
+
+create table BPEL_MESSAGE_EXCHANGE (
+ MESSAGE_EXCHANGE_ID varchar(255) not null,
+ CALLEE varchar(255) null,
+ CHANNEL varchar(255) null,
+ CORRELATION_ID varchar(255) null,
+ CORRELATION_KEYS varchar(255) null,
+ CORRELATION_STATUS varchar(255) null,
+ CREATE_TIME datetime null,
+ DIRECTION char(1) null,
+ EPR text null,
+ FAULT varchar(255) null,
+ FAULT_EXPLANATION varchar(255) null,
+ OPERATION varchar(255) null,
+ PARTNER_LINK_MODEL_ID int null,
+ PATTERN varchar(255) null,
+ PIPED_ID varchar(255) null,
+ PORT_TYPE varchar(255) null,
+ PROPAGATE_TRANS tinyint null,
+ STATUS varchar(255) null,
+ SUBSCRIBER_COUNT int null,
+ CORR_ID numeric(19,0) null,
+ PARTNER_LINK_ID numeric(19,0) null,
+ PROCESS_ID numeric(19,0) null,
+ PROCESS_INSTANCE_ID numeric(19,0) null,
+ REQUEST_MESSAGE_ID numeric(19,0) null,
+ RESPONSE_MESSAGE_ID numeric(19,0) null,
+ primary key (MESSAGE_EXCHANGE_ID)
+);
+
+create table BPEL_MESSAGE_ROUTE (
+ MESSAGE_ROUTE_ID numeric(19,0) identity not null,
+ CORRELATION_KEY varchar(255) null,
+ GROUP_ID varchar(255) null,
+ ROUTE_INDEX int null,
+ PROCESS_INSTANCE_ID numeric(19,0) null,
+ ROUTE_POLICY varchar(16) null,
+ CORR_ID numeric(19,0) null,
+ primary key (MESSAGE_ROUTE_ID)
+);
+
+create table BPEL_MEX_PROP (
+ ID numeric(19,0) identity not null,
+ MEX_ID varchar(255) null,
+ PROP_KEY varchar(255) null,
+ PROP_VALUE varchar(2000) null,
+ primary key (ID)
+);
+
+create table BPEL_PARTNER_LINK (
+ PARTNER_LINK_ID numeric(19,0) identity not null,
+ MY_EPR text null,
+ MY_ROLE_NAME varchar(255) null,
+ MY_ROLE_SERVICE_NAME varchar(255) null,
+ MY_SESSION_ID varchar(255) null,
+ PARTNER_EPR text null,
+ PARTNER_LINK_MODEL_ID int null,
+ PARTNER_LINK_NAME varchar(255) null,
+ PARTNER_ROLE_NAME varchar(255) null,
+ PARTNER_SESSION_ID varchar(255) null,
+ SCOPE_ID numeric(19,0) null,
+ primary key (PARTNER_LINK_ID)
+);
+
+create table BPEL_PROCESS (
+ ID numeric(19,0) identity not null,
+ GUID varchar(255) null,
+ PROCESS_ID varchar(255) null,
+ PROCESS_TYPE varchar(255) null,
+ VERSION numeric(19,0) null,
+ primary key (ID)
+);
+
+create table BPEL_PROCESS_INSTANCE (
+ ID numeric(19,0) identity not null,
+ DATE_CREATED datetime null,
+ EXECUTION_STATE image null,
+ FAULT_ID numeric(19,0) null,
+ LAST_ACTIVE_TIME datetime null,
+ LAST_RECOVERY_DATE datetime null,
+ PREVIOUS_STATE smallint null,
+ SEQUENCE numeric(19,0) null,
+ INSTANCE_STATE smallint null,
+ INSTANTIATING_CORRELATOR_ID numeric(19,0) null,
+ PROCESS_ID numeric(19,0) null,
+ ROOT_SCOPE_ID numeric(19,0) null,
+ primary key (ID)
+);
+
+create table BPEL_SCOPE (
+ SCOPE_ID numeric(19,0) identity not null,
+ MODEL_ID int null,
+ SCOPE_NAME varchar(255) null,
+ SCOPE_STATE varchar(255) null,
+ PARENT_SCOPE_ID numeric(19,0) null,
+ PROCESS_INSTANCE_ID numeric(19,0) null,
+ primary key (SCOPE_ID)
+);
+
+create table BPEL_XML_DATA (
+ XML_DATA_ID numeric(19,0) identity not null,
+ DATA text null,
+ IS_SIMPLE_TYPE tinyint null,
+ NAME varchar(255) null,
+ SCOPE_ID numeric(19,0) null,
+ primary key (XML_DATA_ID)
+);
+
+create table BPEL_XML_DATA_PROP (
+ ID numeric(19,0) identity not null,
+ XML_DATA_ID numeric(19,0) null,
+ PROP_KEY varchar(255) null,
+ PROP_VALUE varchar(255) null,
+ primary key (ID)
+);
+
+create table STORE_DU (
+ NAME varchar(255) not null,
+ DEPLOYDT datetime null,
+ DEPLOYER varchar(255) null,
+ DIR varchar(255) null,
+ primary key (NAME)
+);
+
+create table STORE_PROCESS (
+ PID varchar(255) not null,
+ STATE varchar(255) null,
+ TYPE varchar(255) null,
+ VERSION numeric(19,0) null,
+ DU varchar(255) null,
+ primary key (PID)
+);
+
+create table STORE_PROCESS_PROP (
+ ID numeric(19,0) identity not null,
+ PROP_KEY varchar(255) null,
+ PROP_VAL varchar(255) null,
+ primary key (ID)
+);
+
+create table STORE_PROC_TO_PROP (
+ STORE_PROCESS_PID varchar(255) not null,
+ STORE_PROPERTY_ID numeric(19,0) not null,
+ primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID),
+ unique (STORE_PROPERTY_ID)
+);
+
+create table STORE_VERSIONS (
+ ID numeric(19,0) identity not null,
+ VERSION numeric(19,0) null,
+ primary key (ID)
+);
\ No newline at end of file
13 years, 8 months
riftsaw SVN: r1057 - in branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main: scripts and 1 other directory.
by riftsaw-commits＠lists.jboss.org
Author: jeff.yuchang
Date: 2010-10-24 23:28:46 -0400 (Sun, 24 Oct 2010)
New Revision: 1057
Added:
branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/files/hibernate.cfg/sybase.properties
branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/scripts/simplesched-sybase.sql
Log:
* RIFTSAW-306, added support for sybase db.
Added: branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/files/hibernate.cfg/sybase.properties
===================================================================
--- branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/files/hibernate.cfg/sybase.properties (rev 0)
+++ branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/files/hibernate.cfg/sybase.properties 2010-10-25 03:28:46 UTC (rev 1057)
@@ -0,0 +1 @@
+dialect=org.hibernate.dialect.SybaseDialect
\ No newline at end of file
Added: branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/scripts/simplesched-sybase.sql
===================================================================
--- branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/scripts/simplesched-sybase.sql (rev 0)
+++ branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main/scripts/simplesched-sybase.sql 2010-10-25 03:28:46 UTC (rev 1057)
@@ -0,0 +1,28 @@
+-- Apache ODE - SimpleScheduler Database Schema
+--
+-- Apache Derby scripts by Maciej Szefler.
+--
+--
+
+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 IMAGE null,
+
+ PRIMARY KEY(jobid));
+
+CREATE INDEX IDX_ODE_JOB_TS ON ODE_JOB(ts);
+CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid);
\ No newline at end of file
13 years, 8 months
