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