Index: lams_common/src/java/org/lamsfoundation/lams/commonContext.xml =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/commonContext.xml,v diff -u -r1.100.2.13 -r1.100.2.14 --- lams_common/src/java/org/lamsfoundation/lams/commonContext.xml 15 Dec 2014 10:09:24 -0000 1.100.2.13 +++ lams_common/src/java/org/lamsfoundation/lams/commonContext.xml 15 Dec 2014 11:00:15 -0000 1.100.2.14 @@ -227,7 +227,7 @@ - + org.springframework.scheduling.quartz.LocalDataSourceJobStore Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02040038.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql 15 Dec 2014 10:09:24 -0000 1.1.2.1 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql 15 Dec 2014 11:00:15 -0000 1.1.2.2 @@ -60,16 +60,16 @@ -- add new 'sched_name' COLUMN to all tables -ALTER TABLE lams_qtz_blob_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_calendars ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_cron_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_fired_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_job_details ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_locks ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_paused_trigger_grps ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_scheduler_state ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_simple_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; -ALTER TABLE lams_qtz_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LamsQuartzScheduler' FIRST; +ALTER TABLE lams_qtz_blob_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_calendars ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_cron_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_fired_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_job_details ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_locks ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_paused_trigger_grps ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_scheduler_state ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_simple_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; +ALTER TABLE lams_qtz_triggers ADD COLUMN sched_name VARCHAR(120) NOT NULL DEFAULT 'LAMS' FIRST; -- drop all primary and foreign key constraints, so that we can define new ones