Quartz Upgrade from 1.6 to 2.4 version

[aapathak1221]

Hi,

I am trying to upgrade quartz from version 1.6 to 2.4 using migration steps URL:.

Database is MySql8

Below Create Table statement throws an error

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 BOOL NULL,
BOOL_PROP_2 BOOL 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)
);

Error: : ERROR 3780 (HY000): Referencing column 'SCHED_NAME' and referenced column 'sched_name' in foreign key constraint 'qrtz_simprop_triggers_ibfk_1' are incompatible.

QRTZ_TRIGGERS Table as below:

mysql> desc QRTZ_TRIGGERS;
+----------------+--------------+------+-----+---------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------------+-------+
| TRIGGER_NAME | varchar(200) | NO | PRI | NULL | |
| TRIGGER_GROUP | varchar(200) | NO | PRI | NULL | |
| JOB_NAME | varchar(200) | NO | | NULL | |
| JOB_GROUP | varchar(200) | NO | | NULL | |
| DESCRIPTION | varchar(250) | YES | | NULL | |
| NEXT_FIRE_TIME | bigint(13) | YES | | NULL | |
| PREV_FIRE_TIME | bigint(13) | YES | | NULL | |
| PRIORITY | int(11) | YES | | NULL | |
| TRIGGER_STATE | varchar(16) | NO | | NULL | |
| TRIGGER_TYPE | varchar(8) | NO | | NULL | |
| START_TIME | bigint(13) | NO | | NULL | |
| END_TIME | bigint(13) | YES | | NULL | |
| CALENDAR_NAME | varchar(200) | YES | | NULL | |
| MISFIRE_INSTR | smallint(2) | YES | | NULL | |
| JOB_DATA | blob | YES | | NULL | |
| sched_name | varchar(120) | NO | PRI | TestScheduler | |
+----------------+--------------+------+-----+---------------+-------+

[ericjs]

I'm curious what the solution was...I have project that uses Quartz 1.6 that I might want to upgrade? How hard was the process and did the migration guide for upgrading from 1.8 mostly work? Can you offer any tips?