Sahina Bose has posted comments on this change. Change subject: engine: DB persistent quartz scheduler ......................................................................
Patch Set 7: (1 comment) @Yair, AFAIK, JDBC JobStore works with a pre-defined schema and is not customizable. We may need to write and maintain our own JobStore to be able to customize and control the db schema, and is not trivial. http://gerrit.ovirt.org/#/c/36297/7/packaging/dbscripts/upgrade/03_06_0590_insert_quartz_tables.sql File packaging/dbscripts/upgrade/03_06_0590_insert_quartz_tables.sql: Line 63: times_triggered BIGINT NOT NULL, Line 64: PRIMARY KEY (sched_name,trigger_name,trigger_group) Line 65: ); Line 66: Line 67: SELECT fn_db_create_constraint('qrtz_simple_triggers', 'fk_qrtz_simple_triggers_sched_name', > TWS Oops. Correcting Line 68: 'FOREIGN KEY (sched_name,trigger_name,trigger_group) REFERENCES qrtz_triggers(sched_name,trigger_name,trigger_group) ON DELETE CASCADE'); Line 69: Line 70: CREATE TABLE qrtz_cron_triggers Line 71: ( -- To view, visit http://gerrit.ovirt.org/36297 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I9a34dac95999cb6b3721d201c116fb5f6089bb61 Gerrit-PatchSet: 7 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Sahina Bose <sab...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Liran Zelkha <lzel...@redhat.com> Gerrit-Reviewer: Moti Asayag <masa...@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourf...@redhat.com> Gerrit-Reviewer: Sahina Bose <sab...@redhat.com> Gerrit-Reviewer: Shubhendu Tripathi <shtri...@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzasl...@redhat.com> Gerrit-Reviewer: anmolbabu <anb...@redhat.com> Gerrit-Reviewer: automat...@ovirt.org Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
