svn commit: r957191 - in /ode/trunk/dao-hibernate-db: build.xml src/main/sql/ode.h2.properties src/main/sql/simplesched-h2.sql

[rr...@apache.org]

Author: rr
Date: Wed Jun 23 13:36:57 2010
New Revision: 957191

URL: http://svn.apache.org/viewvc?rev=957191&view=rev
Log:
Added H2 Database schema generation

Added:
    ode/trunk/dao-hibernate-db/src/main/sql/ode.h2.properties
    ode/trunk/dao-hibernate-db/src/main/sql/simplesched-h2.sql
Modified:
    ode/trunk/dao-hibernate-db/build.xml

Modified: ode/trunk/dao-hibernate-db/build.xml
URL: http://svn.apache.org/viewvc/ode/trunk/dao-hibernate-db/build.xml?rev=957191&r1=957190&r2=957191&view=diff
==============================================================================
--- ode/trunk/dao-hibernate-db/build.xml (original)
+++ ode/trunk/dao-hibernate-db/build.xml Wed Jun 23 13:36:57 2010
@@ -50,6 +50,7 @@
 
     <!-- Sybase -->
     <create-ddl db="hsql" />
+    <create-ddl db="h2" />
 
     <!-- MSSQL -->
     <create-ddl db="sqlserver" />

Added: ode/trunk/dao-hibernate-db/src/main/sql/ode.h2.properties
URL: http://svn.apache.org/viewvc/ode/trunk/dao-hibernate-db/src/main/sql/ode.h2.properties?rev=957191&view=auto
==============================================================================
--- ode/trunk/dao-hibernate-db/src/main/sql/ode.h2.properties (added)
+++ ode/trunk/dao-hibernate-db/src/main/sql/ode.h2.properties Wed Jun 23 13:36:57 2010
@@ -0,0 +1,51 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#    http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+
+#
+# Misc. Hibernate DAO Configuration
+# Settings in this file override the defaults.
+#
+
+# The type of database we are connecting to, uncomment the
+# correct one:
+
+#hibernate.dialect=org.hibernate.dialect.DerbyDialect
+hibernate.dialect=org.hibernate.dialect.H2Dialect
+#hibernate.dialect=org.hibernate.dialect.HSQLDialect
+#hibernate.dialect=org.hibernate.dialect.OracleDialect
+#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
+#hibernate.dialect=org.hibernate.dialect.SQLServerDialect
+#hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
+#hibernate.dialect=org.hibernate.dialect.SybaseDialect
+
+#Enable SQL-level debug logging (uncomment for logging)
+#hibernate.show_sql=true
+
+# Enable schema auto-generation.
+hibernate.hbm2ddl.auto = update
+
+# Hibernate / JTA Session Management Conifguration
+hibernate.current_session_context_class=jta
+hibernate.transaction.manager_lookup_class=org.apache.ode.daohib.HibernateTransactionManagerLookup
+
+
+# see Query Language Changes http://www.hibernate.org/250.html: here to prevent
+# problems related to ANTLR class loading. Can be commented out on platforms
+# where new ANTLRs are present
+#hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory

Added: ode/trunk/dao-hibernate-db/src/main/sql/simplesched-h2.sql
URL: http://svn.apache.org/viewvc/ode/trunk/dao-hibernate-db/src/main/sql/simplesched-h2.sql?rev=957191&view=auto
==============================================================================
--- ode/trunk/dao-hibernate-db/src/main/sql/simplesched-h2.sql (added)
+++ ode/trunk/dao-hibernate-db/src/main/sql/simplesched-h2.sql Wed Jun 23 13:36:57 2010
@@ -0,0 +1,31 @@
+-- Apache ODE - SimpleScheduler Database Schema
+--
+-- MySQL scripts by Maciej Szefler.
+--
+--
+DROP TABLE IF EXISTS ODE_JOB;
+
+CREATE TABLE ODE_JOB (
+  jobid CHAR(64)  NOT NULL DEFAULT '',
+  ts BIGINT  NOT NULL DEFAULT 0,
+  nodeid char(64)  NULL,
+  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(4096),
+
+  PRIMARY KEY(jobid)
+);
+
+create index IDX_ODE_JOB_TS on ODE_JOB(ts);
+create index IDX_ODE_JOB_NODEID on ODE_JOB(nodeid);
+