quartz持久化到mysql报错_springboot整合quartz并持久化到数据库

DROP TABLE IF EXISTSQRTZ_FIRED_TRIGGERS;DROP TABLE IF EXISTSQRTZ_PAUSED_TRIGGER_GRPS;DROP TABLE IF EXISTSQRTZ_SCHEDULER_STATE;DROP TABLE IF EXISTSQRTZ_LOCKS;DROP TABLE IF EXISTSQRTZ_SIMPLE_TRIGGERS;DROP TABLE IF EXISTSQRTZ_SIMPROP_TRIGGERS;DROP TABLE IF EXISTSQRTZ_CRON_TRIGGERS;DROP TABLE IF EXISTSQRTZ_BLOB_TRIGGERS;DROP TABLE IF EXISTSQRTZ_TRIGGERS;DROP TABLE IF EXISTSQRTZ_JOB_DETAILS;DROP TABLE IF EXISTSQRTZ_CALENDARS;CREATE TABLEQRTZ_JOB_DETAILS(

SCHED_NAMEVARCHAR(120) NOT NULL,

JOB_NAMEVARCHAR(200) NOT NULL,

JOB_GROUPVARCHAR(200) NOT NULL,

DESCRIPTIONVARCHAR(250) NULL,

JOB_CLASS_NAMEVARCHAR(250) NOT NULL,

IS_DURABLEVARCHAR(1) NOT NULL,

IS_NONCONCURRENTVARCHAR(1) NOT NULL,

IS_UPDATE_DATAVARCHAR(1) NOT NULL,

REQUESTS_RECOVERYVARCHAR(1) NOT NULL,

JOB_DATA BLOBNULL,PRIMARY KEY(SCHED_NAME,JOB_NAME,JOB_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_TRIGGERS (

SCHED_NAMEVARCHAR(120) NOT NULL,

TRIGGER_NAMEVARCHAR(200) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,

JOB_NAMEVARCHAR(200) NOT NULL,

JOB_GROUPVARCHAR(200) NOT NULL,

DESCRIPTIONVARCHAR(250) NULL,

NEXT_FIRE_TIMEBIGINT(13) NULL,

PREV_FIRE_TIMEBIGINT(13) NULL,

PRIORITYINTEGER NULL,

TRIGGER_STATEVARCHAR(16) NOT NULL,

TRIGGER_TYPEVARCHAR(8) NOT NULL,

START_TIMEBIGINT(13) NOT NULL,

END_TIMEBIGINT(13) NULL,

CALENDAR_NAMEVARCHAR(200) NULL,

MISFIRE_INSTRSMALLINT(2) NULL,

JOB_DATA BLOBNULL,PRIMARY KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY(SCHED_NAME,JOB_NAME,JOB_GROUP)REFERENCESQRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_SIMPLE_TRIGGERS (

SCHED_NAMEVARCHAR(120) NOT NULL,

TRIGGER_NAMEVARCHAR(200) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,

REPEAT_COUNTBIGINT(7) NOT NULL,

REPEAT_INTERVALBIGINT(12) NOT NULL,

TIMES_TRIGGEREDBIGINT(10) NOT NULL,PRIMARY KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCESQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_CRON_TRIGGERS (

SCHED_NAMEVARCHAR(120) NOT NULL,

TRIGGER_NAMEVARCHAR(200) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,

CRON_EXPRESSIONVARCHAR(120) NOT NULL,

TIME_ZONE_IDVARCHAR(80),PRIMARY KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCESQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_SIMPROP_TRIGGERS

(

SCHED_NAMEVARCHAR(120) NOT NULL,

TRIGGER_NAMEVARCHAR(200) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,

STR_PROP_1VARCHAR(512) NULL,

STR_PROP_2VARCHAR(512) NULL,

STR_PROP_3VARCHAR(512) NULL,

INT_PROP_1INT NULL,

INT_PROP_2INT NULL,

LONG_PROP_1BIGINT NULL,

LONG_PROP_2BIGINT NULL,

DEC_PROP_1 NUMERIC(13,4) NULL,

DEC_PROP_2 NUMERIC(13,4) NULL,

BOOL_PROP_1VARCHAR(1) NULL,

BOOL_PROP_2VARCHAR(1) NULL,PRIMARY KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCESQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_BLOB_TRIGGERS (

SCHED_NAMEVARCHAR(120) NOT NULL,

TRIGGER_NAMEVARCHAR(200) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,

BLOB_DATA BLOBNULL,PRIMARY KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),INDEX(SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),FOREIGN KEY(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCESQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_CALENDARS (

SCHED_NAMEVARCHAR(120) NOT NULL,

CALENDAR_NAMEVARCHAR(200) NOT NULL,

CALENDAR BLOBNOT NULL,PRIMARY KEY(SCHED_NAME,CALENDAR_NAME))

ENGINE=InnoDB;CREATE TABLEQRTZ_PAUSED_TRIGGER_GRPS (

SCHED_NAMEVARCHAR(120) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,PRIMARY KEY(SCHED_NAME,TRIGGER_GROUP))

ENGINE=InnoDB;CREATE TABLEQRTZ_FIRED_TRIGGERS (

SCHED_NAMEVARCHAR(120) NOT NULL,

ENTRY_IDVARCHAR(95) NOT NULL,

TRIGGER_NAMEVARCHAR(200) NOT NULL,

TRIGGER_GROUPVARCHAR(200) NOT NULL,

INSTANCE_NAMEVARCHAR(200) NOT NULL,

FIRED_TIMEBIGINT(13) NOT NULL,

SCHED_TIMEBIGINT(13) NOT NULL,

PRIORITYINTEGER NOT NULL,

STATEVARCHAR(16) NOT NULL,

JOB_NAMEVARCHAR(200) NULL,

JOB_GROUPVARCHAR(200) NULL,

IS_NONCONCURRENTVARCHAR(1) NULL,

REQUESTS_RECOVERYVARCHAR(1) NULL,PRIMARY KEY(SCHED_NAME,ENTRY_ID))

ENGINE=InnoDB;CREATE TABLEQRTZ_SCHEDULER_STATE (

SCHED_NAMEVARCHAR(120) NOT NULL,

INSTANCE_NAMEVARCHAR(200) NOT NULL,

LAST_CHECKIN_TIMEBIGINT(13) NOT NULL,

CHECKIN_INTERVALBIGINT(13) NOT NULL,PRIMARY KEY(SCHED_NAME,INSTANCE_NAME))

ENGINE=InnoDB;CREATE TABLEQRTZ_LOCKS (

SCHED_NAMEVARCHAR(120) NOT NULL,

LOCK_NAMEVARCHAR(40) NOT NULL,PRIMARY KEY(SCHED_NAME,LOCK_NAME))

ENGINE=InnoDB;CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ONQRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);CREATE INDEX IDX_QRTZ_J_GRP ONQRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);CREATE INDEX IDX_QRTZ_T_J ONQRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);CREATE INDEX IDX_QRTZ_T_JG ONQRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);CREATE INDEX IDX_QRTZ_T_C ONQRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);CREATE INDEX IDX_QRTZ_T_G ONQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);CREATE INDEX IDX_QRTZ_T_STATE ONQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);CREATE INDEX IDX_QRTZ_T_N_STATE ONQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);CREATE INDEX IDX_QRTZ_T_N_G_STATE ONQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ONQRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);CREATE INDEX IDX_QRTZ_T_NFT_ST ONQRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ONQRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ONQRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ONQRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ONQRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ONQRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);CREATE INDEX IDX_QRTZ_FT_J_G ONQRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);CREATE INDEX IDX_QRTZ_FT_JG ONQRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);CREATE INDEX IDX_QRTZ_FT_T_G ONQRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);CREATE INDEX IDX_QRTZ_FT_TG ONQRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);