You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ode.apache.org by bo...@apache.org on 2006/11/15 00:08:28 UTC
svn commit: r475047 - in /incubator/ode/trunk/dao-hibernate-db-derby:
build.xml src/main/sql/ode.firebird.properties
src/main/sql/tables_firebird.sql
Author: boisvert
Date: Tue Nov 14 15:08:27 2006
New Revision: 475047
URL: http://svn.apache.org/viewvc?view=rev&rev=475047
Log:
Add Firebird database profile
Added:
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.firebird.properties
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_firebird.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=475047&r1=475046&r2=475047
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/build.xml (original)
+++ incubator/ode/trunk/dao-hibernate-db-derby/build.xml Tue Nov 14 15:08:27 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="firebird.target.sql" value="${target.dir}/firebird.sql" />
<target name="db" depends="depset, tarball" />
@@ -91,6 +92,9 @@
<concat destfile="${postgres.target.sql}" append="true">
<fileset file="${src.sql.dir}/tables_postgres.sql" />
</concat>
+ <concat destfile="${firebird.target.sql}" append="true">
+ <fileset file="${src.sql.dir}/tables_firebird.sql" />
+ </concat>
</target>
<target name="schemaexport" >
@@ -139,6 +143,17 @@
drop="no"
create="yes"
output="${postgres.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"
+ delimiter=";"
+ drop="no"
+ create="yes"
+ output="${firebird.target.sql}">
<fileset dir="${basedir}/../dao-hibernate/target/generated-resources/xdoclet">
<include name="**/*.hbm.xml"/>
</fileset>
Added: incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.firebird.properties
URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.firebird.properties?view=auto&rev=475047
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.firebird.properties (added)
+++ incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.firebird.properties Tue Nov 14 15:08:27 2006
@@ -0,0 +1,52 @@
+#
+# 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.FirebirdDialect
+#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_firebird.sql
URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_firebird.sql?view=auto&rev=475047
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_firebird.sql (added)
+++ incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_firebird.sql Tue Nov 14 15:08:27 2006
@@ -0,0 +1,143 @@
+-- Firebird DB script submitted by Leonardo Alves
+
+DROP TABLE QRTZ_JOB_LISTENERS;
+DROP TABLE QRTZ_TRIGGER_LISTENERS;
+DROP TABLE QRTZ_FIRED_TRIGGERS;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+DROP TABLE QRTZ_SIMPLE_TRIGGERS;
+DROP TABLE QRTZ_CRON_TRIGGERS;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+DROP TABLE QRTZ_TRIGGERS;
+DROP TABLE QRTZ_JOB_DETAILS;
+DROP TABLE QRTZ_CALENDARS;
+
+
+CREATE TABLE QRTZ_JOB_DETAILS (
+ JOB_NAME VARCHAR(60) NOT NULL,
+ JOB_GROUP VARCHAR(60) NOT NULL,
+ DESCRIPTION VARCHAR(120),
+ 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 BLOB,
+ CONSTRAINT PK_QRTZ_JOB_DETAILS PRIMARY KEY (JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_JOB_LISTENERS (
+ JOB_NAME VARCHAR(60) NOT NULL,
+ JOB_GROUP VARCHAR(60) NOT NULL,
+ JOB_LISTENER VARCHAR(60) NOT NULL,
+ CONSTRAINT PK_QRTZ_JOB_LST PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
+ CONSTRAINT FK_QRTZ_JOB_LST_1 FOREIGN KEY (JOB_NAME,JOB_GROUP)
+ REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGERS (
+ TRIGGER_NAME VARCHAR(60) NOT NULL,
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ JOB_NAME VARCHAR(60) NOT NULL,
+ JOB_GROUP VARCHAR(60) NOT NULL,
+ IS_VOLATILE VARCHAR(1) NOT NULL,
+ DESCRIPTION VARCHAR(120),
+ NEXT_FIRE_TIME BIGINT,
+ PREV_FIRE_TIME BIGINT,
+ TRIGGER_STATE VARCHAR(16) NOT NULL,
+ TRIGGER_TYPE VARCHAR(8) NOT NULL,
+ START_TIME BIGINT NOT NULL,
+ END_TIME BIGINT,
+ CALENDAR_NAME VARCHAR(60),
+ MISFIRE_INSTR SMALLINT,
+ CONSTRAINT PK_QRTZ_TRIGGERS PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+ CONSTRAINT FK_QRTZ_TRIGGERS_1 FOREIGN KEY (JOB_NAME,JOB_GROUP)
+ REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+);
+
+CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
+ TRIGGER_NAME VARCHAR(60) NOT NULL,
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ REPEAT_COUNT BIGINT NOT NULL,
+ REPEAT_INTERVAL BIGINT NOT NULL,
+ TIMES_TRIGGERED BIGINT NOT NULL,
+ CONSTRAINT PK_QRTZ_SIMPLE_TRIGGERS PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+ CONSTRAINT FK_QRTZ_SIMPLE_TRIGGERS_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CRON_TRIGGERS (
+ TRIGGER_NAME VARCHAR(60) NOT NULL,
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ CRON_EXPRESSION VARCHAR(60) NOT NULL,
+ TIME_ZONE_ID VARCHAR(60),
+ CONSTRAINT PK_QRTZ_SIMPLE_TRG PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+ CONSTRAINT FK_QRTZ_SIMPLE_TRG_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_BLOB_TRIGGERS (
+ TRIGGER_NAME VARCHAR(60) NOT NULL,
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ BLOB_DATA BLOB,
+ CONSTRAINT PK_QRTZ_BLOB_TRIGGERS PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
+ CONSTRAINT FK_QRTZ_BLOB_TRIGGERS_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_TRIGGER_LISTENERS (
+ TRIGGER_NAME VARCHAR(60) NOT NULL,
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ TRIGGER_LISTENER VARCHAR(60) NOT NULL,
+ CONSTRAINT PK_QRTZ_TRIGGER_LST PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
+ CONSTRAINT FK_QRTZ_TRIGGER_LST_1 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_CALENDARS (
+ CALENDAR_NAME VARCHAR(60) NOT NULL,
+ CALENDAR BLOB NOT NULL,
+ CONSTRAINT PK_QRTZ_CALENDARS PRIMARY KEY (CALENDAR_NAME)
+);
+
+CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ CONSTRAINT PK_QRTZ_PAUSED_TRIGGER_GRPS PRIMARY KEY (TRIGGER_GROUP)
+);
+
+CREATE TABLE QRTZ_FIRED_TRIGGERS (
+ ENTRY_ID VARCHAR(95) NOT NULL,
+ TRIGGER_NAME VARCHAR(60) NOT NULL,
+ TRIGGER_GROUP VARCHAR(60) NOT NULL,
+ IS_VOLATILE VARCHAR(1) NOT NULL,
+ INSTANCE_NAME VARCHAR(60) NOT NULL,
+ FIRED_TIME BIGINT NOT NULL,
+ STATE VARCHAR(16) NOT NULL,
+ JOB_NAME VARCHAR(60),
+ JOB_GROUP VARCHAR(60),
+ IS_STATEFUL VARCHAR(1),
+ REQUESTS_RECOVERY VARCHAR(1),
+ CONSTRAINT PK_QRTZ_FIRED_TRIGGERS PRIMARY KEY (ENTRY_ID)
+);
+
+CREATE TABLE QRTZ_SCHEDULER_STATE (
+ INSTANCE_NAME VARCHAR(60) NOT NULL,
+ LAST_CHECKIN_TIME BIGINT NOT NULL,
+ CHECKIN_INTERVAL BIGINT NOT NULL,
+ RECOVERER VARCHAR(60),
+ CONSTRAINT PK_QRTZ_SCHEDULER_STATE PRIMARY KEY (INSTANCE_NAME)
+);
+
+CREATE TABLE QRTZ_LOCKS (
+ LOCK_NAME VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_QRTZ_LOCKS 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');
+
+COMMIT;