Uploaded image for project: 'JBeret'
  1. JBeret
  2. JBERET-132

Add constraint name for foreign keys and CASCADE DELETE in job repository DDL

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 1.1.0.Beta1
    • 1.0.0.Final
    • jberet-core
    • None

      add explicit names to these foreign key constraints so they can be more easily referenced by a fixed name.

      also add ON DELETE CASCADE to these foreign key constraints to help deleting unneeded data.

      Compatibility Note:

      Existing jdbc repository database will continue work with its existing schemas, because JBeret batch runtime will only create tables when they do not exist. However, existing batch application should consider altering job repository tables to align with the new DDL.

      jberet-db2.ddl already has foreign key constraint names (JOB_EXECUTION_JOB_INSTANCE_FK, STEP_EXECUTION_JOB_EXECUTION_FK, PARTITION_EXECUTION_STEP_EXECUTION_FK), but is updated to new names to be consistent with other ddl files(FK_JOB_EXECUTION_JOB_INSTANCE, FK_STEP_EXECUTION_JOB_EXECUTION, FK_PARTITION_EXECUTION_STEP_EXECUTION).

            cfang@redhat.com Cheng Fang
            cfang@redhat.com Cheng Fang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: