Author: mriou
Date: Mon Sep 25 10:14:02 2006
New Revision: 449746
URL: http://svn.apache.org/viewvc?view=rev&rev=449746
Log:
Generating scripts for mysql.
Added:
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.mysql.properties
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_mysql_innodb.sql
Removed:
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.derby.sql.old
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=449746&r1=449745&r2=449746
==============================================================================
--- incubator/ode/trunk/dao-hibernate-db-derby/build.xml (original)
+++ incubator/ode/trunk/dao-hibernate-db-derby/build.xml Mon Sep 25 10:14:02
2006
@@ -18,86 +18,102 @@
-->
<project name="dao-hibernate-db-derby" default="db" >
- <property name="database.dir" value="${basedir}/target/derby" />
- <property name="database.name" value="data" />
+ <property name="database.dir" value="${basedir}/target/derby" />
+ <property name="database.name" value="data" />
- <property name="target.dir" value="${basedir}/target" />
- <property name="src.sql.dir" value="${basedir}/src/main/sql" />
+ <property name="target.dir" value="${basedir}/target" />
+ <property name="src.sql.dir" value="${basedir}/src/main/sql" />
- <property name="target.sql" value="${target.dir}/derby.sql" />
+ <property name="derby.target.sql" value="${target.dir}/derby.sql" />
+ <property name="mysql.target.sql" value="${target.dir}/mysql.sql" />
- <target name="db" depends="depset, tarball" />
-
- <target name="depset" >
- <dependset>
- <srcfileset dir="${basedir}/src/main/sql"
- includes="**/*" />
- <targetfileset dir="${target.dir}" includes="tarball.tar" />
- </dependset>
-
- <available property="skip.tar" file="${target.dir}/tarball.tar" />
- <available property="skip.sql" file="${target.dir}/tarball.tar" />
- </target>
-
- <target name="tarball" unless="skip.tar" >
- <antcall inheritRefs="true" target="dbload" />
- <tar destfile="${basedir}/target/tarball.tar"
- basedir="${database.dir}/">
- <include name="${database.name}/**" />
- </tar>
- </target>
-
- <target name="dbload" >
- <antcall inheritRefs="true" target="derby-shutdown" />
- <delete dir="${database.dir}"/>
- <sql driver="org.apache.derby.jdbc.EmbeddedDriver"
- url="jdbc:derby:${database.dir}/${database.name};create=true"
- userid="sa" password="" src="${target.sql}"
- autocommit="true" onerror="abort" delimiter=";"
- classpathref="maven.dependency.classpath">
- </sql>
-
- <antcall inheritRefs="true" target="derby-shutdown" />
- </target>
-
- <target name="derby-shutdown">
- <java classname="org.apache.derby.tools.ij"
- append="true"
- failonerror="true"
- classpathref="maven.dependency.classpath" >
- <arg value="${basedir}/shutdown.sql"/>
- </java>
- </target>
-
- <target name="schemagen" unless="skip.sql" >
- <antcall inheritRefs="true" target="schemaexport" />
-
- <!-- Append the QUARTZ tables -->
- <concat destfile="${target.sql}" append="true">
- <fileset file="${src.sql.dir}/tables_derby.sql" />
- </concat>
- </target>
-
- <target name="schemaexport" >
- <taskdef name="schemaexport"
- classname="org.hibernate.tool.hbm2ddl.SchemaExportTask"
- classpathref="maven.dependency.classpath" />
-
- <mkdir dir="${target.dir}" />
- <schemaexport properties="${src.sql.dir}/ode.derby.properties"
- quiet="yes"
- text="yes"
- delimiter=";"
- drop="no"
- create="yes"
- output="${target.sql}" >
-
- <fileset
dir="${basedir}/../dao-hibernate/target/generated-resources/xdoclet">
- <include name="**/*.hbm.xml"/>
- </fileset>
+ <target name="db" depends="depset, tarball" />
+
+ <target name="depset" >
+ <dependset>
+ <srcfileset dir="${basedir}/src/main/sql"
+ includes="**/*" />
+ <targetfileset dir="${target.dir}" includes="tarball.tar" />
+ </dependset>
+
+ <available property="skip.tar" file="${target.dir}/tarball.tar" />
+ <available property="skip.sql" file="${target.dir}/tarball.tar" />
+ </target>
+
+ <target name="tarball" unless="skip.tar" >
+ <antcall inheritRefs="true" target="dbload" />
+ <copy todir="${database.dir}/${database.name}">
+ <fileset dir="${target.dir}" includes="*.sql" />
+ </copy>
+ <tar destfile="${basedir}/target/tarball.tar"
+ basedir="${database.dir}/">
+ <include name="${database.name}/**" />
+ </tar>
+ </target>
+
+ <target name="dbload" >
+ <antcall inheritRefs="true" target="derby-shutdown" />
+ <delete dir="${database.dir}"/>
+ <sql driver="org.apache.derby.jdbc.EmbeddedDriver"
+ url="jdbc:derby:${database.dir}/${database.name};create=true"
+ userid="sa" password="" src="${derby.target.sql}"
+ autocommit="true" onerror="abort" delimiter=";"
+ classpathref="maven.dependency.classpath">
+ </sql>
+
+ <antcall inheritRefs="true" target="derby-shutdown" />
+ </target>
+
+ <target name="derby-shutdown">
+ <java classname="org.apache.derby.tools.ij"
+ append="true"
+ failonerror="true"
+ classpathref="maven.dependency.classpath" >
+ <arg value="${basedir}/shutdown.sql"/>
+ </java>
+ </target>
+
+ <target name="schemagen" unless="skip.sql" >
+ <antcall inheritRefs="true" target="schemaexport" />
+
+ <!-- Append the QUARTZ tables -->
+ <concat destfile="${derby.target.sql}" append="true">
+ <fileset file="${src.sql.dir}/tables_derby.sql" />
+ </concat>
+ <concat destfile="${mysql.target.sql}" append="true">
+ <fileset file="${src.sql.dir}/tables_mysql_innodb.sql" />
+ </concat>
+ </target>
+
+ <target name="schemaexport" >
+ <taskdef name="schemaexport"
+ classname="org.hibernate.tool.hbm2ddl.SchemaExportTask"
+ classpathref="maven.dependency.classpath" />
+
+ <mkdir dir="${target.dir}" />
+ <schemaexport properties="${src.sql.dir}/ode.derby.properties"
+ quiet="yes"
+ text="yes"
+ delimiter=";"
+ drop="no"
+ create="yes"
+ output="${derby.target.sql}">
+ <fileset
dir="${basedir}/../dao-hibernate/target/generated-resources/xdoclet">
+ <include name="**/*.hbm.xml"/>
+ </fileset>
+ </schemaexport>
+ <schemaexport properties="${src.sql.dir}/ode.mysql.properties"
+ quiet="yes"
+ text="yes"
+ delimiter=";"
+ drop="no"
+ create="yes"
+ output="${mysql.target.sql}">
+ <fileset
dir="${basedir}/../dao-hibernate/target/generated-resources/xdoclet">
+ <include name="**/*.hbm.xml"/>
+ </fileset>
+ </schemaexport>
+ </target>
- </schemaexport>
-
- </target>
</project>
Added:
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.mysql.properties
URL:
http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.mysql.properties?view=auto&rev=449746
==============================================================================
---
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.mysql.properties
(added)
+++
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/ode.mysql.properties
Mon Sep 25 10:14:02 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_mysql_innodb.sql
URL:
http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_mysql_innodb.sql?view=auto&rev=449746
==============================================================================
---
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_mysql_innodb.sql
(added)
+++
incubator/ode/trunk/dao-hibernate-db-derby/src/main/sql/tables_mysql_innodb.sql
Mon Sep 25 10:14:02 2006
@@ -0,0 +1 @@
+#
# In your Quartz properties file, you'll need to set
# org.quartz.jobStore.driverDelegateClass =
org.quartz.impl.jdbcjobstore.StdJDBCDelegate
#
#
# By: Ron Cordell - roncordell
# I didn't see this anywhere, so I thought I'd post it here. This is the
script from Quartz to create the tables in a MySQL database, modified to use
INNODB instead of MYISAM.
DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
DROP TABLE IF EXISTS QRTZ_LOCKS;
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
DROP TABLE IF EXISTS QRTZ_CALENDARS;
CREATE TABLE QRTZ_JOB_DETAILS(
JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(120) NULL,
JOB_CLASS_NAME VAR
CHAR(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 NULL,
PRIMARY KEY (JOB_NAME,JOB_GROUP))
TYPE=InnoDB;
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),
INDEX (JOB_NAME, JOB_GROUP),
FOREIGN KEY (JOB_NAME,JOB_GROUP)
REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP))
TYPE=InnoDB;
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 BIGINT(13) NULL,
PREV_FIRE_TIME BIGINT(13) NULL,
TRIGGER_STATE VARCHAR(16) NOT NULL,
TRIGGER_TYPE VARCHAR(8) NOT NULL,
START_TIME BIGINT(13) NOT NULL,
END_TIME BIGINT(13) NULL,
CALENDAR_NAME VARCHAR(80) NULL,
MISFIRE_I
NSTR SMALLINT(2) NULL,
JOB_DATA BLOB NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
INDEX (JOB_NAME, JOB_GROUP),
FOREIGN KEY (JOB_NAME,JOB_GROUP)
REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP))
TYPE=InnoDB;
CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
REPEAT_COUNT BIGINT(7) NOT NULL,
REPEAT_INTERVAL BIGINT(12) NOT NULL,
TIMES_TRIGGERED BIGINT(7) NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
INDEX (TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
TYPE=InnoDB;
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),
INDEX (TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
TYPE=InnoDB;
CREATE TABLE QRTZ_BLO
B_TRIGGERS (
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
BLOB_DATA BLOB NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
INDEX (TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
TYPE=InnoDB;
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),
INDEX (TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
TYPE=InnoDB;
CREATE TABLE QRTZ_CALENDARS (
CALENDAR_NAME VARCHAR(80) NOT NULL,
CALENDAR BLOB NOT NULL,
PRIMARY KEY (CALENDAR_NAME))
TYPE=InnoDB;
CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
TRIGGER_GROUP VARCHAR(80) NOT NULL,
PRIMARY KEY (TRIGGER_GROUP))
TYPE=InnoDB;
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 BIGINT(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))
TYPE=InnoDB;
CREATE TABLE QRTZ_SCHEDULER_STATE (
INSTANCE_NAME VARCHAR(80) NOT NULL,
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13) NOT NULL,
RECOVERER VARCHAR(80) NULL,
PRIMARY KEY (INSTANCE_NAME))
TYPE=InnoDB;
CREATE TABLE QRTZ_LOCKS (
LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (LOCK_NAME))
TYPE=InnoDB;
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;
\ No newline at end of file
