Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-2/test.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-2/test.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-2/test.properties (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-2/test.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace=http://ode/bpel/unit-test.wsdl service=HelloService operation=hello
Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-3/test.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-3/test.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-3/test.properties (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestVersionedRedeploy/HelloWorld-3/test.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace=http://ode/bpel/unit-test.wsdl service=HelloService operation=hello Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestWait1/test.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestWait1/test.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestWait1/test.properties (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestWait1/test.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace=http://ode/bpel/unit-test/testTimer.wsdl service=TestService operation=testOperation Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace1/test1.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace1/test1.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace1/test1.properties (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace1/test1.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace=http://ode/bpel/unit-test/TestXPathNamespace1.wsdl service=TestXPathNamespace1Service operation=request Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace2/test1.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace2/test1.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace2/test1.properties (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXPathNamespace2/test1.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace=http://ode/bpel/unit-test/TestXPathNamespace2.wsdl service=TestXPathNamespace2Service operation=operation1 Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/HelloXslWorld.xsl URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/HelloXslWorld.xsl?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/HelloXslWorld.xsl (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/HelloXslWorld.xsl Thu May 17 16:43:51 2007 @@ -1,3 +1,22 @@ +<!-- + ~ 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. + --> + <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0"> <xsl:output method="xml"/> <xsl:param name="middle"/> Modified: incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/test.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/test.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/test.properties (original) +++ incubator/ode/trunk/bpel-test/src/test/resources/bpel/2.0/TestXslTransform/test.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace=http://ode/bpel/unit-test.wsdl service=HelloXslService operation=helloXsl Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_derby.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_derby.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_derby.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_derby.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +-- IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + -- -- Apache Derby scripts by Steve Stewart. -- Based on Srinivas Venkatarangaiah's file for Cloudscape Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_firebird.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_firebird.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_firebird.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_firebird.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +-- IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + -- Firebird DB script submitted by Leonardo Alves DROP TABLE QRTZ_JOB_LISTENERS; Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_hsql.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_hsql.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_hsql.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_hsql.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +# IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + # # In your Quartz properties file, you'll need to set # org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_mysql_innodb.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_mysql_innodb.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_mysql_innodb.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_mysql_innodb.sql Thu May 17 16:43:51 2007 @@ -1 +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 +# IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS # # 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 VARCH AR(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 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, E ND_TIME BIGINT(13) NULL, CALENDAR_NAME VARCHAR(80) NULL, MISFIRE_INSTR 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_TRIGGER S(TRIGGER_NAME,TRIGGER_GROUP)) TYPE=InnoDB; CREATE TABLE QRTZ_BLOB_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_T RIGGERS ( 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 Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_oracle.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_oracle.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_oracle.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_oracle.sql Thu May 17 16:43:51 2007 @@ -1 +1 @@ --- -- A hint submitted by a user: Oracle DB MUST be created as "shared" and the -- job_queue_processes parameter must be greater than 2, otherwise a DB lock -- will happen. However, these settings are pretty much standard after any -- Oracle install, so most users need not worry about this. -- delete from qrtz_job_listeners; delete from qrtz_trigger_listeners; delete from qrtz_fired_triggers; delete from qrtz_simple_triggers; delete from qrtz_cron_triggers; delete from qrtz_blob_triggers; delete from qrtz_triggers; delete from qrtz_job_details; delete from qrtz_calendars; delete from qrtz_paused_trigger_grps; delete from qrtz_locks; delete from qrtz_scheduler_state; drop table qrtz_calendars; drop table qrtz_fired_triggers; drop table qrtz_trigger_listeners; drop table qrtz_blob_triggers; drop table qrtz_cron_triggers; drop table qrtz_simple_triggers; drop table qrtz_triggers; drop table qrtz_job_listeners; drop table qrtz_job_details; drop table qrtz_paused_trigger_g rps; drop table qrtz_locks; drop table qrtz_scheduler_state; CREATE TABLE qrtz_job_details ( JOB_NAME VARCHAR2(80) NOT NULL, JOB_GROUP VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(120) NULL, JOB_CLASS_NAME VARCHAR2(128) NOT NULL, IS_DURABLE VARCHAR2(1) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, IS_STATEFUL VARCHAR2(1) NOT NULL, REQUESTS_RECOVERY VARCHAR2(1) NOT NULL, JOB_DATA BLOB NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP) ); CREATE TABLE qrtz_job_listeners ( JOB_NAME VARCHAR2(80) NOT NULL, JOB_GROUP VARCHAR2(80) NOT NULL, JOB_LISTENER VARCHAR2(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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, JOB_NAME VARCHAR2(80) NOT NULL, JOB_GROUP VARCHAR2(80) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL , DESCRIPTION VARCHAR2(120) NULL, NEXT_FIRE_TIME NUMBER(13) NULL, PREV_FIRE_TIME NUMBER(13) NULL, TRIGGER_STATE VARCHAR2(16) NOT NULL, TRIGGER_TYPE VARCHAR2(8) NOT NULL, START_TIME NUMBER(13) NOT NULL, END_TIME NUMBER(13) NULL, CALENDAR_NAME VARCHAR2(80) NULL, MISFIRE_INSTR NUMBER(2) NULL, JOB_DATA BLOB 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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, REPEAT_COUNT NUMBER(7) NOT NULL, REPEAT_INTERVAL NUMBER(12) NOT NULL, TIMES_TRIGGERED NUMBER(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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL , CRON_EXPRESSION VARCHAR2(80) NOT NULL, TIME_ZONE_ID VARCHAR2(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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, BLOB_DATA BLOB 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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, TRIGGER_LISTENER VARCHAR2(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 VARCHAR2(80) NOT NULL, CALENDAR BLOB NOT NULL, PRIMARY KEY (CALENDAR_NAME ) ); CREATE TABLE qrtz_paused_trigger_grps ( TRIGGER_GROUP VARCHAR2(80) NOT NULL, PRIMARY KEY (TRIGGER_GROUP) ); CREATE TABLE qrtz_fired_triggers ( ENTRY_ID VARCHAR2(95) NOT NULL, TRIGGER_NAME VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, INSTANCE_NAME VARCHAR2(80) NOT NULL, FIRED_TIME NUMBER(13) NOT NULL, STATE VARCHAR2(16) NOT NULL, JOB_NAME VARCHAR2(80) NULL, JOB_GROUP VARCHAR2(80) NULL, IS_STATEFUL VARCHAR2(1) NULL, REQUESTS_RECOVERY VARCHAR2(1) NULL, PRIMARY KEY (ENTRY_ID) ); CREATE TABLE qrtz_scheduler_state ( INSTANCE_NAME VARCHAR2(80) NOT NULL, LAST_CHECKIN_TIME NUMBER(13) NOT NULL, CHECKIN_INTERVAL NUMBER(13) NOT NULL, RECOVERER VARCHAR2(80) NULL, PRIMARY KEY (INSTANCE_NAME) ); CREATE TABLE qrtz_locks ( LOCK_NAME VARCHAR2(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'); create index idx_qrtz_j_req_recovery on qrtz_job_details(REQUESTS_RECOVERY); create index idx_qrtz_t_next_fire_time on qrtz_triggers(NEXT_FIRE_TIME); create index idx_qrtz_t_state on qrtz_triggers(TRIGGER_STATE); create index idx_qrtz_t_nft_st on qrtz_triggers(NEXT_FIRE_TIME,TRIGGER_STATE); create index idx_qrtz_t_volatile on qrtz_triggers(IS_VOLATILE); create index idx_qrtz_ft_trig_name on qrtz_fired_triggers(TRIGGER_NAME); create index idx_qrtz_ft_trig_group on qrtz_fired_triggers(TRIGGER_GROUP); create index idx_qrtz_ft_trig_nm_gp on qrtz_fired_triggers(TRIGGER_NAME,TRIGGER_GROUP); create index idx_qrtz_ft_trig_volatile on qrtz_fired_triggers(IS_VOLATILE); create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(INSTANCE_NAME); create index idx_qrtz_ft_job_name on qrtz_fired_triggers(JOB_NA ME); create index idx_qrtz_ft_job_group on qrtz_fired_triggers(JOB_GROUP); create index idx_qrtz_ft_job_stateful on qrtz_fired_triggers(IS_STATEFUL); create index idx_qrtz_ft_job_req_recovery on qrtz_fired_triggers(REQUESTS_RECOVERY); commit; \ No newline at end of file +-- IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS -- -- A hint submitted by a user: Oracle DB MUST be created as "shared" and the -- job_queue_processes parameter must be greater than 2, otherwise a DB lock -- will happen. However, these settings are pretty much standard after any -- Oracle install, so most users need not worry about this. -- delete from qrtz_job_listeners; delete from qrtz_trigger_listeners; delete from qrtz_fired_triggers; delete from qrtz_simple_triggers; delete from qrtz_cron_triggers; delete from qrtz_blob_triggers; delete from qrtz_triggers; delete from qrtz_job_details; delete from qrtz_calendars; delete from qrtz_paused_trigger_grps; delete from qrtz_locks; delete from qrtz_scheduler_state; drop table qrtz_calendars; drop table qrtz_fired_triggers; drop table qrtz_trigger_listeners; drop table qrtz_blob_triggers; drop table qrtz_cron_triggers; drop table qrtz_simple_triggers; drop table qrtz_triggers; drop table qrtz_job_listen ers; drop table qrtz_job_details; drop table qrtz_paused_trigger_grps; drop table qrtz_locks; drop table qrtz_scheduler_state; CREATE TABLE qrtz_job_details ( JOB_NAME VARCHAR2(80) NOT NULL, JOB_GROUP VARCHAR2(80) NOT NULL, DESCRIPTION VARCHAR2(120) NULL, JOB_CLASS_NAME VARCHAR2(128) NOT NULL, IS_DURABLE VARCHAR2(1) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, IS_STATEFUL VARCHAR2(1) NOT NULL, REQUESTS_RECOVERY VARCHAR2(1) NOT NULL, JOB_DATA BLOB NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP) ); CREATE TABLE qrtz_job_listeners ( JOB_NAME VARCHAR2(80) NOT NULL, JOB_GROUP VARCHAR2(80) NOT NULL, JOB_LISTENER VARCHAR2(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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, JOB_NAME VARCHAR2(80) NOT NULL, JOB _GROUP VARCHAR2(80) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, DESCRIPTION VARCHAR2(120) NULL, NEXT_FIRE_TIME NUMBER(13) NULL, PREV_FIRE_TIME NUMBER(13) NULL, TRIGGER_STATE VARCHAR2(16) NOT NULL, TRIGGER_TYPE VARCHAR2(8) NOT NULL, START_TIME NUMBER(13) NOT NULL, END_TIME NUMBER(13) NULL, CALENDAR_NAME VARCHAR2(80) NULL, MISFIRE_INSTR NUMBER(2) NULL, JOB_DATA BLOB 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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, REPEAT_COUNT NUMBER(7) NOT NULL, REPEAT_INTERVAL NUMBER(12) NOT NULL, TIMES_TRIGGERED NUMBER(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_N AME VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, CRON_EXPRESSION VARCHAR2(80) NOT NULL, TIME_ZONE_ID VARCHAR2(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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, BLOB_DATA BLOB 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 VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, TRIGGER_LISTENER VARCHAR2(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 VARCHAR2(80) NOT NULL, CALENDAR BLOB NOT NULL, PRIMARY KEY (CALENDAR_NAME) ); CREATE TABLE qrtz_paused_trigger_grps ( TRIGGER_GROUP VARCHAR2(80) NOT NULL, PRIMARY KEY (TRIGGER_GROUP) ); CREATE TABLE qrtz_fired_triggers ( ENTRY_ID VARCHAR2(95) NOT NULL, TRIGGER_NAME VARCHAR2(80) NOT NULL, TRIGGER_GROUP VARCHAR2(80) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, INSTANCE_NAME VARCHAR2(80) NOT NULL, FIRED_TIME NUMBER(13) NOT NULL, STATE VARCHAR2(16) NOT NULL, JOB_NAME VARCHAR2(80) NULL, JOB_GROUP VARCHAR2(80) NULL, IS_STATEFUL VARCHAR2(1) NULL, REQUESTS_RECOVERY VARCHAR2(1) NULL, PRIMARY KEY (ENTRY_ID) ); CREATE TABLE qrtz_scheduler_state ( INSTANCE_NAME VARCHAR2(80) NOT NULL, LAST_CHECKIN_TIME NUMBER(13) NOT NULL, CHECKIN_INTERVAL NUMBER(13) NOT NULL, RECOVERER VARCHAR2(80) NULL, PRIMARY KEY (INSTANCE_NAME) ); CREATE TABLE qrtz_locks ( LOCK_NAME VARCHAR2(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'); create index idx_qrtz_j_req_recovery on qrtz_job_details(REQUESTS_RECOVERY); create index idx_qrtz_t_next_fire_time on qrtz_triggers(NEXT_FIRE_TIME); create index idx_qrtz_t_state on qrtz_triggers(TRIGGER_STATE); create index idx_qrtz_t_nft_st on qrtz_triggers(NEXT_FIRE_TIME,TRIGGER_STATE); create index idx_qrtz_t_volatile on qrtz_triggers(IS_VOLATILE); create index idx_qrtz_ft_trig_name on qrtz_fired_triggers(TRIGGER_NAME); create index idx_qrtz_ft_trig_group on qrtz_fired_triggers(TRIGGER_GROUP); create index idx_qrtz_ft_trig_nm_gp on qrtz_fired_triggers(TRIGGER_NAME,TRIGGER_GROUP); create index idx_qrtz_ft_trig_volatile on qrtz_fired_triggers(IS_VOLATILE); create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(INSTANCE_NAME ); create index idx_qrtz_ft_job_name on qrtz_fired_triggers(JOB_NAME); create index idx_qrtz_ft_job_group on qrtz_fired_triggers(JOB_GROUP); create index idx_qrtz_ft_job_stateful on qrtz_fired_triggers(IS_STATEFUL); create index idx_qrtz_ft_job_req_recovery on qrtz_fired_triggers(REQUESTS_RECOVERY); commit; \ No newline at end of file Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_postgres.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_postgres.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_postgres.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_postgres.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +# IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + # Thanks to Patrick Lightbody for submitting this... # # In your Quartz properties file, you'll need to set Modified: incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_sqlserver.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_sqlserver.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_sqlserver.sql (original) +++ incubator/ode/trunk/dao-hibernate-db/src/main/sql/tables_sqlserver.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +--# IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + --# thanks to George Papastamatopoulos for submitting this ... and Marko Lahma for --# updating it. --# Modified: incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-derby.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-derby.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-derby.sql (original) +++ incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-derby.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +-- IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + -- -- Apache Derby scripts by Steve Stewart. -- Based on Srinivas Venkatarangaiah's file for Cloudscape Modified: incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-firebird.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-firebird.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-firebird.sql (original) +++ incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-firebird.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,4 @@ +-- IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS -- Firebird DB script submitted by Leonardo Alves DROP TABLE QRTZ_JOB_LISTENERS; Modified: incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-innodb.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-innodb.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-innodb.sql (original) +++ incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-innodb.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +# IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + # # In your Quartz properties file, you'll need to set # org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate Modified: incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-sqlserver.sql URL: http://svn.apache.org/viewvc/incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-sqlserver.sql?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-sqlserver.sql (original) +++ incubator/ode/trunk/dao-jpa-ojpa-derby/src/main/scripts/quartz-sqlserver.sql Thu May 17 16:43:51 2007 @@ -1,3 +1,5 @@ +--# IMPORTED FROM OPENSYMPHONY QUARTZ, SEE NOTICE FILE FOR DETAILS + --# thanks to George Papastamatopoulos for submitting this ... and Marko Lahma for --# updating it. --# Modified: incubator/ode/trunk/distro-jbi/src/examples/example.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/distro-jbi/src/examples/example.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/distro-jbi/src/examples/example.properties (original) +++ incubator/ode/trunk/distro-jbi/src/examples/example.properties Thu May 17 16:43:51 2007 @@ -1,4 +1,21 @@ # +# 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. +# + +# # customize any properties for your environment # ode.start.args=-v -console Modified: incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/ChannelListener.xdt URL: http://svn.apache.org/viewvc/incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/ChannelListener.xdt?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/ChannelListener.xdt (original) +++ incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/ChannelListener.xdt Thu May 17 16:43:51 2007 @@ -1,4 +1,21 @@ /* + * 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. + * * SOURCE FILE GENERATATED BY JACOB CHANNEL CLASS GENERATOR * !!! DO NOT EDIT !!!! */ Modified: incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/channel.xdt URL: http://svn.apache.org/viewvc/incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/channel.xdt?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/channel.xdt (original) +++ incubator/ode/trunk/jacob/src/xdt/org/apache/ode/jacob/channel.xdt Thu May 17 16:43:51 2007 @@ -1,4 +1,21 @@ /* + * 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. + * * SOURCE FILE GENERATATED BY JACOB CHANNEL CLASS GENERATOR * !!! DO NOT EDIT !!!! */ Modified: incubator/ode/trunk/jbi/src/test/resources/carol.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/jbi/src/test/resources/carol.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/jbi/src/test/resources/carol.properties (original) +++ incubator/ode/trunk/jbi/src/test/resources/carol.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + # JNDI (Protocol Invocation) #carol.protocols=jrmp Modified: incubator/ode/trunk/jbi/src/test/resources/log4j.properties URL: http://svn.apache.org/viewvc/incubator/ode/trunk/jbi/src/test/resources/log4j.properties?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/jbi/src/test/resources/log4j.properties (original) +++ incubator/ode/trunk/jbi/src/test/resources/log4j.properties Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + # Set root logger level to WARN and its only appender to CONSOLE log4j.rootLogger=WARN, CONSOLE Modified: incubator/ode/trunk/tasks/clover.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/clover.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/clover.rake (original) +++ incubator/ode/trunk/tasks/clover.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + module Clover REQUIRES = Buildr.artifacts("clover:clover:jar:1.3.11") Modified: incubator/ode/trunk/tasks/cobertura.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/cobertura.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/cobertura.rake (original) +++ incubator/ode/trunk/tasks/cobertura.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + module Cobertura class << self Modified: incubator/ode/trunk/tasks/derby.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/derby.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/derby.rake (original) +++ incubator/ode/trunk/tasks/derby.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + module Derby REQUIRES = Buildr.group("derby", "derbytools", :under=>"org.apache.derby", :version=>"10.1.2.1") Modified: incubator/ode/trunk/tasks/headers.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/headers.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/headers.rake (original) +++ incubator/ode/trunk/tasks/headers.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + namespace "check" do desc "Checks license headers." @@ -44,7 +61,26 @@ ~ under the License. --> EOF - licenses[".bpel"] = licenses[".wsdl"] = licenses[".xml"] + licenses[".properties"] = <<EOF +# +# 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. +# +EOF + licenses[".bpel"] = licenses[".wsdl"] = licenses[".xsd"] = licenses['.usd'] = licenses['.xsl'] = licenses[".xml"] + licenses[".rake"] = licenses[".tdef"] = licenses[".properties"] # This also tells us which files to look at. extensions = licenses.keys.join(",") count = FileList["**/*{#{extensions}}"].inject(0) do |count, filename| @@ -52,8 +88,17 @@ when_writing "Missing header in #{filename}" do # Figure the license from the file, inject it into the file and rewrite it. license = licenses[filename.pathmap("%x")] - modified = File.read(filename).sub(/(<\?xml .*\?>\n?)(.*)/m) { "#{$1}#{license}#{$2}" } - File.open(filename, "w") { |file| file.write modified } + if license + content = File.read(filename) + if (content =~ /<\?xml .*\?>/) + modified = content.sub(/(<\?xml .*\?>\n?)(.*)/m) { "#{$1}#{license}#{$2}" } + else + modified = license + "\n" + content + end + File.open(filename, "w") { |file| file.write modified } + else + puts "Skipping unknown extension for file #{filename}" + end count + 1 end else Modified: incubator/ode/trunk/tasks/hibernate.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/hibernate.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/hibernate.rake (original) +++ incubator/ode/trunk/tasks/hibernate.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + module Hibernate REQUIRES = Buildr.struct( Modified: incubator/ode/trunk/tasks/jbi.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/jbi.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/jbi.rake (original) +++ incubator/ode/trunk/tasks/jbi.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + # This task creates a JBI package based on the component/bootstrap specification. # It extends ZipTask, and all its over lovely options. # Modified: incubator/ode/trunk/tasks/jdepend.rake URL: http://svn.apache.org/viewvc/incubator/ode/trunk/tasks/jdepend.rake?view=diff&rev=539175&r1=539174&r2=539175 ============================================================================== --- incubator/ode/trunk/tasks/jdepend.rake (original) +++ incubator/ode/trunk/tasks/jdepend.rake Thu May 17 16:43:51 2007 @@ -1,3 +1,20 @@ +# +# 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. +# + module Jdepend REQUIRES = ["jdepend:jdepend:jar:2.9.1"]
