Details

    • Type: Bug
    • Status: Closed
    • Priority: 2 Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: 2.1
    • Component/s: Documentation
    • Labels:
      None
    • Terracotta Target:
      Quartz 2.1.0
    • Fixed In Revision:
      1607

      Description

      SQL error for derby in version 2.0.2.
      derby create table sql for nullable, good for "no null", bad for " null".
      for example:
      CREATE TABLE qrtz_simprop_triggers
      (
      sched_name varchar(120) not null,
      TRIGGER_NAME VARCHAR(200) NOT NULL,
      TRIGGER_GROUP VARCHAR(200) NOT NULL,
      STR_PROP_1 VARCHAR(512) NULL,
      STR_PROP_2 VARCHAR(512) NULL,
      STR_PROP_3 VARCHAR(512) NULL,
      INT_PROP_1 INT NULL,
      INT_PROP_2 INT NULL,
      LONG_PROP_1 BIGINT NULL,
      LONG_PROP_2 BIGINT NULL,
      DEC_PROP_1 NUMERIC(13,4) NULL,
      DEC_PROP_2 NUMERIC(13,4) NULL,
      BOOL_PROP_1 varchar(5) NULL,
      BOOL_PROP_2 varchar(5) NULL,
      PRIMARY KEY (sched_name,TRIGGER_NAME,TRIGGER_GROUP),
      FOREIGN KEY (sched_name,TRIGGER_NAME,TRIGGER_GROUP)
      REFERENCES QRTZ_TRIGGERS(sched_name,TRIGGER_NAME,TRIGGER_GROUP)
      );
      line STR_PROP_1 VARCHAR(512) NULL,
      should be STR_PROP_1 VARCHAR(512),

        Attachments

          Activity

            People

            • Assignee:
              jhouse James House
              Reporter:
              jacklond Jacklondon Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: