Author: jeff.yuchang Date: 2010-09-30 23:31:10 -0400 (Thu, 30 Sep 2010) New Revision: 1000 Modified: trunk/distribution/src/main/release/ReleaseNotes.txt trunk/pom.xml trunk/qa/jdbc/db2.properties trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql Log: * update the Generated ID type for postgres, also formmatted DDL a little bit. * update Release Notes for 2.2.0 M1 release. Modified: trunk/distribution/src/main/release/ReleaseNotes.txt =================================================================== --- trunk/distribution/src/main/release/ReleaseNotes.txt 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/distribution/src/main/release/ReleaseNotes.txt 2010-10-01 03:31:10 UTC (rev 1000) @@ -1,3 +1,29 @@ +RiftSaw 2.2.0.M1 +================== + +This is the first milestone release for the 2.2.0 release series. + +This release's main feature is the 'clustering support'. Now users are able to deploy Riftsaw +within a clustered environment using a shared database. The BPEL artifact is deployed using the +farm capability, by placing the BPEL process jar into $Server/all/farm folder, which will result +in it being automatically copied to all nodes in the clustered environment. + +Other changes include: +- Added JPA based implementation for SimpleScheduler module DAO, and used it by default in this release. +- Support for DB2 database. +- Using deploy.xml as preference over bpel-deploy.xml as the bpel artifact descriptor. + (It supports both at the moment, but bpel-deploy.xml is deprecated, may gets removed in the near future.) + +Last but not least, we've fixed a bunch of bugs. + +The detailed report for this release can be found at: +https://jira.jboss.org/secure/ReleaseNote.jspa?projectId=12310843&version=12314155 + +Known issues: +RIFTSAW-198 : CronScheduler is not supporting cluster +RIFTSAW-282 : Active, Retire do not work in clustering environment. + + RiftSaw 2.1.0.Final =================== Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/pom.xml 2010-10-01 03:31:10 UTC (rev 1000) @@ -75,9 +75,10 @@ </profiles> <properties> - <riftsaw.ode.version>2.2.0-SNAPSHOT</riftsaw.ode.version> + <riftsaw.ode.version>2.2.0.20101001-M1</riftsaw.ode.version> <riftsaw.engine.version>2.2.0-SNAPSHOT</riftsaw.engine.version> <bpel.console.version>2.1.2</bpel.console.version> + <activity.monitor.model.version>1.0.0-Beta1</activity.monitor.model.version> <commons.logging.version>1.1.1</commons.logging.version> <junit.version>4.8.1</junit.version> <jboss.version>5.1.0.GA</jboss.version> @@ -128,7 +129,7 @@ <dependency> <groupId>org.jboss.bpm</groupId> <artifactId>activity-monitor-model</artifactId> - <version>1.0.0-SNAPSHOT</version> + <version>${activity.monitor.model.version}</version> </dependency> <dependency> Modified: trunk/qa/jdbc/db2.properties =================================================================== --- trunk/qa/jdbc/db2.properties 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/qa/jdbc/db2.properties 2010-10-01 03:31:10 UTC (rev 1000) @@ -3,8 +3,3 @@ username=riftsaw password=riftsaw dialect=org.hibernate.dialect.DB2Dialect -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 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 02:43:36 UTC (rev 999) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/db2.sql 2010-10-01 03:31:10 UTC (rev 1000) @@ -245,29 +245,29 @@ ); create table BPAF_EVENT ( - EID bigint generated by default as identity, - ACTIVITY_DEFINITION_ID varchar(255), - ACTIVITY_INSTANCE_ID varchar(255), - ACTIVITY_NAME varchar(255), - CURRENT_STATE varchar(255), - PREVIOUS_STATE varchar(255), - PROCESS_DEFINITION_ID varchar(255), - PROCESS_INSTANCE_ID varchar(255), - PROCESS_NAME varchar(255), - SERVER_ID varchar(255), - TIMESTAMP bigint, - primary key (EID) + EID bigint generated by default as identity, + ACTIVITY_DEFINITION_ID varchar(255), + ACTIVITY_INSTANCE_ID varchar(255), + ACTIVITY_NAME varchar(255), + CURRENT_STATE varchar(255), + PREVIOUS_STATE varchar(255), + PROCESS_DEFINITION_ID varchar(255), + PROCESS_INSTANCE_ID varchar(255), + PROCESS_NAME varchar(255), + SERVER_ID varchar(255), + TIMESTAMP bigint, + primary key (EID) ); - create table BPAF_EVENT_DATA ( - TID bigint generated by default as identity, - NAME varchar(255), - VALUE varchar(255), - EVENT_ID bigint, - primary key (TID) - ); +create table BPAF_EVENT_DATA ( + TID bigint generated by default as identity, + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) +); - alter table BPAF_EVENT_DATA - add constraint FK3E83D1BCDA848C8 - foreign key (EVENT_ID) - references BPAF_EVENT; +alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-10-01 03:31:10 UTC (rev 1000) @@ -249,32 +249,32 @@ primary key (ID) ) type=InnoDB; - create table BPAF_EVENT ( - EID bigint not null auto_increment, - ACTIVITY_DEFINITION_ID varchar(255), - ACTIVITY_INSTANCE_ID varchar(255), - ACTIVITY_NAME varchar(255), - CURRENT_STATE varchar(255), - PREVIOUS_STATE varchar(255), - PROCESS_DEFINITION_ID varchar(255), - PROCESS_INSTANCE_ID varchar(255), - PROCESS_NAME varchar(255), - SERVER_ID varchar(255), - TIMESTAMP bigint, - primary key (EID) - ); +create table BPAF_EVENT ( + EID bigint not null auto_increment, + ACTIVITY_DEFINITION_ID varchar(255), + ACTIVITY_INSTANCE_ID varchar(255), + ACTIVITY_NAME varchar(255), + CURRENT_STATE varchar(255), + PREVIOUS_STATE varchar(255), + PROCESS_DEFINITION_ID varchar(255), + PROCESS_INSTANCE_ID varchar(255), + PROCESS_NAME varchar(255), + SERVER_ID varchar(255), + TIMESTAMP bigint, + primary key (EID) + ) type=InnoDB;; - create table BPAF_EVENT_DATA ( - TID bigint not null auto_increment, - NAME varchar(255), - VALUE varchar(255), - EVENT_ID bigint, - primary key (TID) - ); +create table BPAF_EVENT_DATA ( + TID bigint not null auto_increment, + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) +) type=InnoDB;; - alter table BPAF_EVENT_DATA - add index FK3E83D1BCDA848C8 (EVENT_ID), - add constraint FK3E83D1BCDA848C8 - foreign key (EVENT_ID) - references BPAF_EVENT (EID); +alter table BPAF_EVENT_DATA + add index FK3E83D1BCDA848C8 (EVENT_ID), + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT (EID); Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-10-01 03:31:10 UTC (rev 1000) @@ -246,32 +246,30 @@ create sequence bpel_sequence; - create table BPAF_EVENT ( - EID number(19,0) not null, - ACTIVITY_DEFINITION_ID varchar2(255 char), - ACTIVITY_INSTANCE_ID varchar2(255 char), - ACTIVITY_NAME varchar2(255 char), - CURRENT_STATE varchar2(255 char), - PREVIOUS_STATE varchar2(255 char), - PROCESS_DEFINITION_ID varchar2(255 char), - PROCESS_INSTANCE_ID varchar2(255 char), - PROCESS_NAME varchar2(255 char), - SERVER_ID varchar2(255 char), - TIMESTAMP number(19,0), - primary key (EID) - ); +create table BPAF_EVENT ( + EID number(19,0) not null, + ACTIVITY_DEFINITION_ID varchar2(255 char), + ACTIVITY_INSTANCE_ID varchar2(255 char), + ACTIVITY_NAME varchar2(255 char), + CURRENT_STATE varchar2(255 char), + PREVIOUS_STATE varchar2(255 char), + PROCESS_DEFINITION_ID varchar2(255 char), + PROCESS_INSTANCE_ID varchar2(255 char), + PROCESS_NAME varchar2(255 char), + SERVER_ID varchar2(255 char), + TIMESTAMP number(19,0), + primary key (EID) + ); - create table BPAF_EVENT_DATA ( - TID number(19,0) not null, - NAME varchar2(255 char), - VALUE varchar2(255 char), - EVENT_ID number(19,0), - primary key (TID) - ); +create table BPAF_EVENT_DATA ( + TID number(19,0) not null, + NAME varchar2(255 char), + VALUE varchar2(255 char), + EVENT_ID number(19,0), + primary key (TID) +); - alter table BPAF_EVENT_DATA - add constraint FK3E83D1BCDA848C8 - foreign key (EVENT_ID) - references BPAF_EVENT; - - create sequence hibernate_sequence; +alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-10-01 03:31:10 UTC (rev 1000) @@ -247,7 +247,7 @@ create sequence bpel_sequence; create table BPAF_EVENT ( - EID bigint generated by default as identity, + EID int8 not null, ACTIVITY_DEFINITION_ID varchar(255), ACTIVITY_INSTANCE_ID varchar(255), ACTIVITY_NAME varchar(255), @@ -261,15 +261,15 @@ primary key (EID) ); - create table BPAF_EVENT_DATA ( - TID bigint generated by default as identity, - NAME varchar(255), - VALUE varchar(255), - EVENT_ID bigint, - primary key (TID) - ); +create table BPAF_EVENT_DATA ( + TID int8 not null, + NAME varchar(255), + VALUE varchar(255), + EVENT_ID bigint, + primary key (TID) +); - alter table BPAF_EVENT_DATA - add constraint FK3E83D1BCDA848C8 - foreign key (EVENT_ID) - references BPAF_EVENT; +alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-10-01 02:43:36 UTC (rev 999) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-10-01 03:31:10 UTC (rev 1000) @@ -259,16 +259,16 @@ primary key (EID) ); - create table BPAF_EVENT_DATA ( - TID numeric(19,0) identity not null, - NAME varchar(255) null, - VALUE varchar(255) null, - EVENT_ID numeric(19,0) null, - primary key (TID) - ); +create table BPAF_EVENT_DATA ( + TID numeric(19,0) identity not null, + NAME varchar(255) null, + VALUE varchar(255) null, + EVENT_ID numeric(19,0) null, + primary key (TID) +); - alter table BPAF_EVENT_DATA - add constraint FK3E83D1BCDA848C8 - foreign key (EVENT_ID) - references BPAF_EVENT; +alter table BPAF_EVENT_DATA + add constraint FK3E83D1BCDA848C8 + foreign key (EVENT_ID) + references BPAF_EVENT;