Author: mriou
Date: Thu Nov 16 15:01:04 2006
New Revision: 475964
URL: http://svn.apache.org/viewvc?view=rev&rev=475964
Log:
Script generation for HSQL.
Added:
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.hsql.properties
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_hsqldb.sql
Modified:
incubator/ode/trunk/dao-hibernate-db-derby/build.xml
Modified: incubator/ode/trunk/dao-hibernate-db-derby/build.xml
URL:
http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/build.xml?view=diff&rev=475964&r1=475963&r2=475964
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/build.xml (original)
+++ incubator/ode/trunk/dao-hibernate-db-derby/build.xml Thu Nov 16 15:01:04
2006
@@ -28,6 +28,7 @@
<property name="mysql.target.sql" value="${target.dir}/mysql.sql" />
<property name="sqls.target.sql" value="${target.dir}/sqlserver.sql" />
<property name="postgres.target.sql" value="${target.dir}/postgres.sql" />
+ <property name="hsql.target.sql" value="${target.dir}/hsql.sql" />
<property name="firebird.target.sql" value="${target.dir}/firebird.sql" />
<target name="db" depends="depset, tarball" />
@@ -92,6 +93,9 @@
<concat destfile="${postgres.target.sql}" append="true">
<fileset file="${src.sql.dir}/tables_postgres.sql" />
</concat>
+ <concat destfile="${hsql.target.sql}" append="true">
+ <fileset file="${src.sql.dir}/tables_hsql.sql" />
+ </concat>
<concat destfile="${firebird.target.sql}" append="true">
<fileset file="${src.sql.dir}/tables_firebird.sql" />
</concat>
@@ -147,6 +151,17 @@
<include name="**/*.hbm.xml"/>
</fileset>
</schemaexport>
+ <schemaexport properties="${src.sql.dir}/ode.hsql.properties"
+ quiet="yes"
+ text="yes"
+ delimiter=";"
+ drop="no"
+ create="yes"
+ output="${hsql.target.sql}">
+ <fileset
dir="${basedir}/../dao-hibernate/target/generated-resources/xdoclet">
+ <include name="**/*.hbm.xml"/>
+ </fileset>
+ </schemaexport>
<schemaexport properties="${src.sql.dir}/ode.firebird.properties"
quiet="yes"
text="yes"
@@ -158,7 +173,7 @@
<include name="**/*.hbm.xml"/>
</fileset>
</schemaexport>
- </target>
+; </target>
</project>
Added:
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.hsql.properties
URL:
http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.hsql.properties?view=auto&rev=475964
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.hsql.properties
(added)
+++ incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.hsql.properties
Thu Nov 16 15:01:04 2006
@@ -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.MySQLDialect
+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: incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_hsqldb.sql
URL:
http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_hsqldb.sql?view=auto&rev=475964
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_hsqldb.sql
(added)
+++ incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_hsqldb.sql
Thu Nov 16 15:01:04 2006
@@ -0,0 +1 @@
+#
# In your Quartz properties file, you'll need to set
# org.quartz.jobStore.driverDelegateClass =
org.quartz.impl.jdbcjobstore.HSQLDBDelegate
#
DROP TABLE qrtz_locks IF EXISTS;
DROP TABLE qrtz_scheduler_state IF EXISTS;
DROP TABLE qrtz_fired_triggers IF EXISTS;
DROP TABLE qrtz_paused_trigger_grps IF EXISTS;
DROP TABLE qrtz_calendars IF EXISTS;
DROP TABLE qrtz_trigger_listeners IF EXISTS;
DROP TABLE qrtz_blob_triggers IF EXISTS;
DROP TABLE qrtz_cron_triggers IF EXISTS;
DROP TABLE qrtz_simple_triggers IF EXISTS;
DROP TABLE qrtz_triggers IF EXISTS;
DROP TABLE qrtz_job_listeners IF EXISTS;
DROP TABLE qrtz_job_details IF EXISTS;
CREATE TABLE qrtz_job_details
(
JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(120) NULL,
JOB_CLASS_NAME VARCHAR(128) NOT NULL,
IS_DURABLE VARCHAR(1) NOT NULL,
IS_VOLATILE VARCHAR(1) NOT NULL,
IS_STATEFUL VARCHAR(1) NOT NULL,
REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
JOB_DATA BINARY NULL,
PRIMARY KEY (JOB_NAME,JOB_GRO
UP)
);
CREATE TABLE qrtz_job_listeners
(
JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
JOB_LISTENER VARCHAR(80) NOT NULL,
PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
FOREIGN KEY (JOB_NAME,JOB_GROUP)
REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
);
CREATE TABLE qrtz_triggers
(
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
IS_VOLATILE VARCHAR(1) NOT NULL,
DESCRIPTION VARCHAR(120) NULL,
NEXT_FIRE_TIME NUMERIC(13) NULL,
PREV_FIRE_TIME NUMERIC(13) NULL,
TRIGGER_STATE VARCHAR(16) NOT NULL,
TRIGGER_TYPE VARCHAR(8) NOT NULL,
START_TIME NUMERIC(13) NOT NULL,
END_TIME NUMERIC(13) NULL,
CALENDAR_NAME VARCHAR(80) NULL,
MISFIRE_INSTR NUMERIC(2) NULL,
JOB_DATA BINARY NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (JOB_NAME,JOB_GROUP)
REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
);
CREATE TABLE qrtz_simple_triggers
(
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GRO
UP VARCHAR(80) NOT NULL,
REPEAT_COUNT NUMERIC(7) NOT NULL,
REPEAT_INTERVAL NUMERIC(12) NOT NULL,
TIMES_TRIGGERED NUMERIC(7) NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE qrtz_cron_triggers
(
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
CRON_EXPRESSION VARCHAR(80) NOT NULL,
TIME_ZONE_ID VARCHAR(80),
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE qrtz_blob_triggers
(
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
BLOB_DATA BINARY NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE qrtz_trigger_listeners
(
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
TRIGGER_LISTENER VARCHAR(80)
NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE qrtz_calendars
(
CALENDAR_NAME VARCHAR(80) NOT NULL,
CALENDAR BINARY NOT NULL,
PRIMARY KEY (CALENDAR_NAME)
);
CREATE TABLE qrtz_paused_trigger_grps
(
TRIGGER_GROUP VARCHAR(80) NOT NULL,
PRIMARY KEY (TRIGGER_GROUP)
);
CREATE TABLE qrtz_fired_triggers
(
ENTRY_ID VARCHAR(95) NOT NULL,
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
IS_VOLATILE VARCHAR(1) NOT NULL,
INSTANCE_NAME VARCHAR(80) NOT NULL,
FIRED_TIME NUMERIC(13) NOT NULL,
STATE VARCHAR(16) NOT NULL,
JOB_NAME VARCHAR(80) NULL,
JOB_GROUP VARCHAR(80) NULL,
IS_STATEFUL VARCHAR(1) NULL,
REQUESTS_RECOVERY VARCHAR(1) NULL,
PRIMARY KEY (ENTRY_ID)
);
CREATE TABLE qrtz_scheduler_state
(
INSTANCE_NAME VARCHAR(80) NOT NULL,
LAST_CHECKIN_TIME NUMERIC(13) NOT NULL,
CHECKIN_INTERVAL NUMERIC(13) NOT NULL,
RECOVERER VARCHAR(80) NULL
,
PRIMARY KEY (INSTANCE_NAME)
);
CREATE TABLE qrtz_locks
(
LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (LOCK_NAME)
);
INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
INSERT INTO qrtz_locks values('JOB_ACCESS');
INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
INSERT INTO qrtz_locks values('STATE_ACCESS');
INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
\ No newline at end of file
