[riftsaw-commits] riftsaw SVN: r1057 - in branches/ODE/RiftSaw-ODE-trunk/dao-jpa-hibernate/src/main: scripts and 1 other directory.
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