January 2010 - riftsaw-commits - Jboss List Archives

Hudson build became unstable: RiftSaw-sqlserver #14

by jboss-qa-internal＠redhat.com

See <http://hudson.qa.jboss.com/hudson/job/RiftSaw-sqlserver/14/changes>

16 years, 6 months

1
4
0 / 0

Hudson build became unstable: RiftSaw-oracle #20

by jboss-qa-internal＠redhat.com

See <http://hudson.qa.jboss.com/hudson/job/RiftSaw-oracle/20/changes>

16 years, 6 months

1
1
0 / 0

riftsaw SVN: r464 - trunk/runtime/engine-assembly/src/main/resources/bpel-sql.

by riftsaw-commits＠lists.jboss.org

Author: jeff.yuchang Date: 2010-01-16 06:45:38 -0500 (Sat, 16 Jan 2010) New Revision: 464 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql Log: * update blob(2G) to varbinary. Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-15 11:52:24 UTC (rev 463) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-16 11:45:38 UTC (rev 464) @@ -36,7 +36,7 @@ create table BPEL_SELECTORS (ID bigint generated by default as identity (start with 1), 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 timestamp, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); create table BPEL_UNMATCHED (ID bigint generated by default as identity (start with 1), MEX bigint, CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); create table BPEL_XML_DATA (ID bigint generated by default as identity (start with 1), LDATA_ID bigint, NAME varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table LARGE_DATA (ID bigint generated by default as identity (start with 1), BIN_DATA blob(2G), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table LARGE_DATA (ID bigint generated by default as identity (start with 1), BIN_DATA varbinary, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); create table VAR_PROPERTY (ID bigint generated by default as identity (start with 1), XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, 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);

16 years, 6 months

1
0
0 / 0

Hudson build is unstable: RiftSaw-oracle #18

by jboss-qa-internal＠redhat.com

See <http://hudson.qa.jboss.com/hudson/job/RiftSaw-oracle/18/>

16 years, 6 months

1
1
0 / 0

RiftSaw-oracle - Build # 17 - Failure!

by jboss-qa-internal＠redhat.com

RiftSaw-oracle - Build # 17 - Failure: Check console output at http://hudson.qa.jboss.com/hudson/job/RiftSaw-oracle/17/ to view the results.

16 years, 6 months

1
0
0 / 0

riftsaw SVN: r463 - trunk/distribution/src/main/release/db.

by riftsaw-commits＠lists.jboss.org

Author: jeff.yuchang Date: 2010-01-15 06:52:24 -0500 (Fri, 15 Jan 2010) New Revision: 463 Modified: trunk/distribution/src/main/release/db/build.xml Log: * add copying ojdbc in the db module build script. Modified: trunk/distribution/src/main/release/db/build.xml =================================================================== --- trunk/distribution/src/main/release/db/build.xml 2010-01-15 11:32:02 UTC (rev 462) +++ trunk/distribution/src/main/release/db/build.xml 2010-01-15 11:52:24 UTC (rev 463) @@ -6,18 +6,26 @@ <property name="database" value="postgres" /> <property file="jdbc/${database}.properties" /> + + <condition property="is.ojdbc.available"> + <available file="${basedir}/../../libs/ojdbc14.jar" /> + </condition>  <target name="log.properties"> <echo message="database....... ${database}" /> <echo message="jdbc driver.... ${driver}" /> <echo message="connection url....... ${connection.url}" /> - <echo message="username.. ${username}" /> - </target> + <echo message="username.. ${username}" /> + </target> + + <target name="copy.ojdbc" if="is.ojdbc.available"> + <copy file="${basedir}/../../libs/ojdbc14.jar" todir="${basedir}/drivers"/> + </target>  <target name="create.riftsaw.schema" - depends="log.properties" + depends="log.properties, copy.ojdbc" description="creates the riftsaw tables in the database"> <sql driver="${driver}" url="${connection.url}" @@ -35,7 +43,7 @@  <target name="drop.riftsaw.schema" - depends="log.properties" + depends="log.properties, copy.ojdbc" description="drops the riftsaw tables from the database"> <sql driver="${driver}" url="${connection.url}"

16 years, 6 months

1
0
0 / 0

riftsaw SVN: r462 - trunk/runtime/engine-assembly/src/main/resources/bpel-sql.

by riftsaw-commits＠lists.jboss.org

Author: jeff.yuchang Date: 2010-01-15 06:32:02 -0500 (Fri, 15 Jan 2010) New Revision: 462 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql Log: * update the oracle.sql, it is from http://top.touk.pl/git?p=ode/odeo/.git;a=blob_plain;f=touk/oracle/ode_sch... Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-01-15 10:08:03 UTC (rev 461) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-01-15 11:32:02 UTC (rev 462) @@ -7,17 +7,16 @@ -- CREATE TABLE ode_job ( - jobid CHAR(64) DEFAULT '' NOT NULL, - ts INTEGER DEFAULT 0 NOT NULL, - nodeid char(64), - scheduled int DEFAULT 0 NOT NULL, - transacted int DEFAULT 0 NOT NULL, + jobid VARCHAR(64) NOT NULL, + ts number(37) NOT NULL, + nodeid varchar(64), + scheduled int NOT NULL, + transacted int NOT NULL, details blob, - PRIMARY KEY(jobid) -); + PRIMARY KEY(jobid)); -CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts); -CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid); +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 number(19,0) not null, PIID number(19,0), AID number(19,0), CHANNEL varchar2(255 char), REASON varchar2(255 char), DATE_TIME timestamp, LDATA_ID number(19,0), ACTIONS varchar2(255 char), RETRIES number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); @@ -30,7 +29,7 @@ create table BPEL_INSTANCE (ID number(19,0) not null, INSTANTIATING_CORRELATOR number(19,0), FAULT number(19,0), JACOB_STATE number(19,0), PREVIOUS_STATE number(5,0), PROCESS_ID number(19,0), STATE number(5,0), LAST_ACTIVE_DT timestamp, SEQUENCE number(19,0), FAILURE_COUNT number(10,0), FAILURE_DT timestamp, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_MESSAGE (ID number(19,0) not null, MEX number(19,0), TYPE varchar2(255 char), DATA number(19,0), HEADER number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_MESSAGE_EXCHANGE (ID number(19,0) not null, PORT_TYPE varchar2(255 char), CHANNEL_NAME varchar2(255 char), CLIENTKEY varchar2(255 char), LDATA_EPR_ID number(19,0), LDATA_CEPR_ID number(19,0), REQUEST number(19,0), RESPONSE number(19,0), INSERT_DT timestamp, OPERATION varchar2(255 char), STATE varchar2(255 char), PROCESS number(19,0), PIID number(19,0), DIR char(1 char), PLINK_MODELID number(10,0), PATTERN varchar2(255 char), CORR_STATUS varchar2(255 char), FAULT_TYPE varchar2(255 char), FAULT_EXPL varchar2(255 char), CALLEE varchar2(255 char), PARTNERLINK number(19,0), PIPED_ID varchar2(255 char), SUBSCRIBER_COUNT number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE long, NAME varchar2(255 char) not null, primary key (MEX, NAME)); +create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE varchar2(255 char), NAME varchar2(255 char) not null, primary key (MEX, NAME)); create table BPEL_PLINK_VAL (ID number(19,0) not null, PARTNER_LINK varchar2(100 char) not null, PARTNERROLE varchar2(100 char), MYROLE_EPR number(19,0), PARTNERROLE_EPR number(19,0), PROCESS number(19,0), SCOPE number(19,0), SVCNAME varchar2(255 char), MYROLE varchar2(100 char), MODELID number(10,0), MYSESSIONID varchar2(255 char), PARTNERSESSIONID varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_PROCESS (ID number(19,0) not null, PROCID varchar2(255 char) not null unique, deployer varchar2(255 char), deploydate timestamp, type_name varchar2(255 char), type_ns varchar2(255 char), version number(19,0), ACTIVE_ number(1,0), guid varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table BPEL_SCOPE (ID number(19,0) not null, PIID number(19,0), PARENT_SCOPE_ID number(19,0), STATE varchar2(255 char) not null, NAME varchar2(255 char) not null, MODELID number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); @@ -39,15 +38,17 @@ create table BPEL_XML_DATA (ID number(19,0) not null, LDATA_ID number(19,0), NAME varchar2(255 char) not null, SCOPE_ID number(19,0), PIID number(19,0), IS_SIMPLE_TYPE number(1,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table LARGE_DATA (ID number(19,0) not null, BIN_DATA blob, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); create table VAR_PROPERTY (ID number(19,0) not null, XML_DATA_ID number(19,0), PROP_VALUE varchar2(255 char), PROP_NAME varchar2(255 char) not null, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID)); -create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); -create index IDX_BPEL_CORRELATOR_MSG_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); -create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); -create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); -create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); -create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); -create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); + +create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID) ; +create index IDX_CKEYxx on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY) ; +create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR) ; +create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY) ; +create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID) ; +create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY) ; +create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR) ; create sequence hibernate_sequence; + --create indexes create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ;

16 years, 6 months

1
0
0 / 0

riftsaw SVN: r461 - in trunk: runtime/engine-assembly/src/main/resources/bpel-sql and 1 other directory.

by riftsaw-commits＠lists.jboss.org

Author: jeff.yuchang Date: 2010-01-15 05:08:03 -0500 (Fri, 15 Jan 2010) New Revision: 461 Modified: trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql Log: * RIFTSAW-152 update blob to varbinary for hsqldb * set LOG=1 in the hsql-ds Modified: trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml =================================================================== --- trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml 2010-01-14 05:29:40 UTC (rev 460) +++ trunk/distribution/src/main/release/db/datasource/bpel-hsql-ds.xml 2010-01-15 10:08:03 UTC (rev 461) @@ -19,7 +19,7 @@ name="jboss:service=h2,database=BPELDB"> <attribute name="Database">BPELDB</attribute> <attribute name="DataDir">${jboss.server.data.dir}</attribute> - <attribute name="Flags">;MVCC=true;LOCK_MODE=3;LOG=2;DB_CLOSE_ON_EXIT=FALSE</attribute> + <attribute name="Flags">;MVCC=true;LOCK_MODE=3;LOG=1;DB_CLOSE_ON_EXIT=FALSE</attribute> </mbean> </datasources> Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-14 05:29:40 UTC (rev 460) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-15 10:08:03 UTC (rev 461) @@ -12,7 +12,7 @@ nodeid char(64), scheduled int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, - details blob(4096), + details varbinary, PRIMARY KEY(jobid)); CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts);

16 years, 6 months

1
0
0 / 0

Hudson build is unstable: RiftSaw-oracle #9

by jboss-qa-internal＠redhat.com

See http://hudson.qa.jboss.com/hudson/job/RiftSaw-oracle/9/

16 years, 6 months

1
6
0 / 0

riftsaw SVN: r460 - trunk/qa.

by riftsaw-commits＠lists.jboss.org

Author: jeff.yuchang Date: 2010-01-14 00:29:40 -0500 (Thu, 14 Jan 2010) New Revision: 460 Modified: trunk/qa/hudson-riftsaw-db.sh trunk/qa/hudson-riftsaw-ws.sh Log: * add -Pdocs for the building. Modified: trunk/qa/hudson-riftsaw-db.sh =================================================================== --- trunk/qa/hudson-riftsaw-db.sh 2010-01-13 19:17:02 UTC (rev 459) +++ trunk/qa/hudson-riftsaw-db.sh 2010-01-14 05:29:40 UTC (rev 460) @@ -20,7 +20,7 @@ #build RiftSaw and running unit tests cd .. -mvn clean install +mvn clean install -Pdocs #cleanup the RiftSaw HOME cd qa Modified: trunk/qa/hudson-riftsaw-ws.sh =================================================================== --- trunk/qa/hudson-riftsaw-ws.sh 2010-01-13 19:17:02 UTC (rev 459) +++ trunk/qa/hudson-riftsaw-ws.sh 2010-01-14 05:29:40 UTC (rev 460) @@ -20,7 +20,7 @@ #build RiftSaw and running unit test cd .. -mvn clean install +mvn clean install -Pdocs # run integration test cd qa

16 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

riftsaw-commits January 2010