Author: jeff.yuchang Date: 2010-08-20 03:02:38 -0400 (Fri, 20 Aug 2010) New Revision: 918 Added: branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql Log: * RIFTSAW-269, added db2 scripts. Added: branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties =================================================================== --- branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties (rev 0) +++ branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties 2010-08-20 07:02:38 UTC (rev 918) @@ -0,0 +1 @@ +dialect=org.hibernate.dialect.DB2Dialect \ No newline at end of file Added: branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql =================================================================== --- branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql (rev 0) +++ branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql 2010-08-20 07:02:38 UTC (rev 918) @@ -0,0 +1,30 @@ +-- 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 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); + +