Index: lams_common/src/java/org/lamsfoundation/lams/commonContext.xml =================================================================== diff -u -rc208628989d52041b3765784f4c8cbfd6c80d47b -r118a795019536460b08165470a13fe99544705e8 --- lams_common/src/java/org/lamsfoundation/lams/commonContext.xml (.../commonContext.xml) (revision c208628989d52041b3765784f4c8cbfd6c80d47b) +++ lams_common/src/java/org/lamsfoundation/lams/commonContext.xml (.../commonContext.xml) (revision 118a795019536460b08165470a13fe99544705e8) @@ -227,7 +227,7 @@ - + org.springframework.scheduling.quartz.LocalDataSourceJobStore Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql =================================================================== diff -u -rc208628989d52041b3765784f4c8cbfd6c80d47b -r118a795019536460b08165470a13fe99544705e8 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql (.../patch02040038.sql) (revision c208628989d52041b3765784f4c8cbfd6c80d47b) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql (.../patch02040038.sql) (revision 118a795019536460b08165470a13fe99544705e8) @@ -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