1:40 a.m.
Author: jeff.yuchang
Date: 2009-10-30 02:40:19 -0400 (Fri, 30 Oct 2009)
New Revision: 217
Added:
trunk/qa/hudson-riftsaw-db.sh
Modified:
trunk/distribution/src/main/release/db/sql/mysql.drop.sql
trunk/distribution/src/main/release/db/sql/postgres.drop.sql
trunk/runtime/engine-assembly/resources/bpel-sql/mysql.sql
trunk/runtime/engine-assembly/resources/bpel-sql/postgres.sql
Log:
* Finished the postgres and mysql db test script.
Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2009-10-29 22:22:52 UTC (rev
216)
+++ trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2009-10-30 06:40:19 UTC (rev
217)
@@ -19,7 +19,6 @@
drop table BPEL_XML_DATA;
drop table LARGE_DATA;
drop table VAR_PROPERTY;
-drop table BPEL_RES_ROUTE;
drop table STORE_DU;
drop table STORE_PROCESS;
drop table STORE_PROCESS_PROP;
@@ -27,4 +26,3 @@
-
Modified: trunk/distribution/src/main/release/db/sql/postgres.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2009-10-29 22:22:52 UTC
(rev 216)
+++ trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2009-10-30 06:40:19 UTC
(rev 217)
@@ -19,12 +19,13 @@
drop table BPEL_XML_DATA;
drop table LARGE_DATA;
drop table VAR_PROPERTY;
-drop table BPEL_RES_ROUTE;
drop table STORE_DU;
drop table STORE_PROCESS;
drop table STORE_PROCESS_PROP;
drop table STORE_VERSIONS;
+drop sequence hibernate_sequence;
+
Added: trunk/qa/hudson-riftsaw-db.sh
===================================================================
--- trunk/qa/hudson-riftsaw-db.sh (rev 0)
+++ trunk/qa/hudson-riftsaw-db.sh 2009-10-30 06:40:19 UTC (rev 217)
@@ -0,0 +1,37 @@
+#!/bin/sh
+#
+# Run Riftsaw Integration tests.
+
+MAVEN_OPTS="-Xms512M -Xmx1024M"
+RIFTSAW_PARENT_DIR="/local/deploy/riftsaw"
+JBOSS_VERSION="5.1.0.GA"
+DATABASE="postgres"
+
+ANT_PROPERTIES="-Driftsaw.parent.dir=$RIFTSAW_PARENT_DIR -Ddatabase=$DATABASE"
+echo ANT_PROPERTIES=${ANT_PROPERTIES}
+
+# firstly build the Riftsaw and run unit tests
+echo build RiftSaw and running unit test
+cd ..
+mvn clean install
+
+# run integration test
+echo cleanup the RiftSaw HOME
+cd qa
+ant $ANT_PROPERTIES clean
+ant $ANT_PROPERTIES install.jbossesb
+
+# clean up the database
+echo clean up the database
+cd ../db
+ant drop.riftsaw.schema -Ddatabase=$DATABASE
+
+RIFTSAW_VERSION="2.0-SNAPSHOT"
+ESB_HOME="$RIFTSAW_PARENT_DIR/riftsaw-$RIFTSAW_VERSION/jboss-$JBOSS_VERSION"
+ESB_CONFIG="default"
+
+echo build the RiftSaw and run integration tests
+echo ESB_HOME=$ESB_HOME, ESB_CONIFG=$ESB_CONFIG
+
+cd ../integration-tests
+mvn -Dorg.jboss.esb.server.home=$ESB_HOME -Dorg.jboss.esb.server.config=$ESB_CONFIG
-Ddatabase=$DATABASE clean install
Property changes on: trunk/qa/hudson-riftsaw-db.sh
___________________________________________________________________
Name: svn:executable
+ *
Modified: trunk/runtime/engine-assembly/resources/bpel-sql/mysql.sql
===================================================================
--- trunk/runtime/engine-assembly/resources/bpel-sql/mysql.sql 2009-10-29 22:22:52 UTC
(rev 216)
+++ trunk/runtime/engine-assembly/resources/bpel-sql/mysql.sql 2009-10-30 06:40:19 UTC
(rev 217)
@@ -39,7 +39,7 @@
create table BPEL_SELECTORS (ID bigint not null auto_increment, PIID bigint not null,
SELGRPID varchar(255) not null, IDX integer not null, CORRELATION_KEY varchar(255) not
null, PROC_TYPE varchar(255) not null, ROUTE_POLICY varchar(255), CORRELATOR bigint not
null, INSERT_TIME datetime, MLOCK integer not null, primary key (ID), unique
(CORRELATION_KEY, CORRELATOR));
create table BPEL_UNMATCHED (ID bigint not null auto_increment, MEX bigint,
CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME datetime, MLOCK
integer not null, primary key (ID));
create table BPEL_XML_DATA (ID bigint not null auto_increment, LDATA_ID bigint, NAME
varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME
datetime, MLOCK integer not null, primary key (ID));
-create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob(2G),
INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob, INSERT_TIME
datetime, MLOCK integer not null, primary key (ID));
create table VAR_PROPERTY (ID bigint not null auto_increment, XML_DATA_ID bigint,
PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME datetime, MLOCK
integer not null, primary key (ID));
create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID);
create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY);
Modified: trunk/runtime/engine-assembly/resources/bpel-sql/postgres.sql
===================================================================
--- trunk/runtime/engine-assembly/resources/bpel-sql/postgres.sql 2009-10-29 22:22:52 UTC
(rev 216)
+++ trunk/runtime/engine-assembly/resources/bpel-sql/postgres.sql 2009-10-30 06:40:19 UTC
(rev 217)
@@ -12,7 +12,7 @@
nodeid char(64),
scheduled int NOT NULL DEFAULT 0,
transacted int NOT NULL DEFAULT 0,
- details blob(4096),
+ details bytea,
PRIMARY KEY(jobid));
CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts);
@@ -36,7 +36,7 @@
create table BPEL_SELECTORS (ID int8 not null, PIID int8 not null, SELGRPID varchar(255)
not null, IDX int4 not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255)
not null, ROUTE_POLICY varchar(255), CORRELATOR int8 not null, INSERT_TIME timestamp,
MLOCK int4 not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR));
create table BPEL_UNMATCHED (ID int8 not null, MEX int8, CORRELATION_KEY varchar(255),
CORRELATOR int8 not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
create table BPEL_XML_DATA (ID int8 not null, LDATA_ID int8, NAME varchar(255) not null,
SCOPE_ID int8, PIID int8, IS_SIMPLE_TYPE bool, INSERT_TIME timestamp, MLOCK int4 not null,
primary key (ID));
-create table LARGE_DATA (ID int8 not null, BIN_DATA blob(2G), INSERT_TIME timestamp,
MLOCK int4 not null, primary key (ID));
+create table LARGE_DATA (ID int8 not null, BIN_DATA bytea, INSERT_TIME timestamp, MLOCK
int4 not null, primary key (ID));
create table VAR_PROPERTY (ID int8 not null, XML_DATA_ID int8, PROP_VALUE varchar(255),
PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key
(ID));
create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID);
create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY);