xxl-job适配达梦数据库

源码地址：

https://github.com/xuxueli/xxl-job

Xxl-job表结构导入

建议用方法二：

方法一：达梦迁移工具

1.打开达梦迁移工具新建工程

2.新建迁移，如下图：

 3.选择迁移方式

4.输入MySQL的信息

5. 输入dm的信息

 6.选择迁移选项默认即可。

 7.指定模式

8.指定对象：全选然后下一步

 审阅迁移任务之后，点击完成

9.完成迁移向导

10.验证是否迁移达梦数据库成功

从上图可知，表结构已经导入成功。

解决刚刚那个xxl_job_group数据问题，重新导入一条示例数据。查看xxl_job_group：如下图：表中无数据。

插入一条示例数据，手动添加即可（根据xxl_job表的示例）。

方法二：手动导入 

1. 创建表空间（XXLJOB)
2. 创建用户并设置密码(XXLJOB)
3. 给XXLJOB用户授权
4. 创建xxl-job的表结构
5. 添加示例数据，注意提交（commit）

注意：此方法也可以使用达梦管理工具，只不过在创建xxl-job表结构时候切换创建的用户XXLJOB进行创建。

参考如下表中sql所示:  其中表空间和建表语句中的表空间一致

--创建表空间

CREATE TABLESPACE  "XXLJOB" DATAFILE 'XXLJOB.DBF' SIZE 300 autoextend on maxsize 67108863 CACHE = NORMAL;

--创建用户

CREATE USER "XXLJOB" IDENTIFIED BY "XXLJOB!123" LIMIT PASSWORD_LOCK_TIME 1, PASSWORD_GRACE_TIME 10 DEFAULT TABLESPACE "XXLJOB";

--给用户授权

GRANT "RESOURCE","PUBLIC","DBA","VTI" TO "XXLJOB";

# 创建xxl-job的表结构

CREATE TABLE "XXLJOB"."XXL_JOB_GROUP"

(

"ID" INT IDENTITY(2, 1) NOT NULL,

"APP_NAME" VARCHAR(64) NOT NULL,

"TITLE" VARCHAR(12) NOT NULL,

"ADDRESS_TYPE" INT DEFAULT 0 NOT NULL,

"ADDRESS_LIST" TEXT,

"UPDATE_TIME" TIMESTAMP(0),

NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "XXLJOB", CLUSTERBTR) ;

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_GROUP"."ADDRESS_LIST" IS '执行器地址列表，多地址逗号分隔';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_GROUP"."ADDRESS_TYPE" IS '执行器地址类型：0=自动注册、1=手动录入';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_GROUP"."APP_NAME" IS '执行器AppName';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_GROUP"."TITLE" IS '执行器名称';

CREATE TABLE "XXLJOB"."XXL_JOB_INFO"

(

"ID" INT IDENTITY(2, 1) NOT NULL,

"JOB_GROUP" INT NOT NULL,

"JOB_DESC" VARCHAR(255) NOT NULL,

"ADD_TIME" TIMESTAMP(0),

"UPDATE_TIME" TIMESTAMP(0),

"AUTHOR" VARCHAR(64),

"ALARM_EMAIL" VARCHAR(255),

"SCHEDULE_TYPE" VARCHAR(50) DEFAULT 'NONE' NOT NULL,

"SCHEDULE_CONF" VARCHAR(128),

"MISFIRE_STRATEGY" VARCHAR(50) DEFAULT 'DO_NOTHING' NOT NULL,

"EXECUTOR_ROUTE_STRATEGY" VARCHAR(50),

"EXECUTOR_HANDLER" VARCHAR(255),

"EXECUTOR_PARAM" VARCHAR(512),

"EXECUTOR_BLOCK_STRATEGY" VARCHAR(50),

"EXECUTOR_TIMEOUT" INT DEFAULT 0 NOT NULL,

"EXECUTOR_FAIL_RETRY_COUNT" INT DEFAULT 0 NOT NULL,

"GLUE_TYPE" VARCHAR(50) NOT NULL,

"GLUE_SOURCE" CLOB,

"GLUE_REMARK" VARCHAR(128),

"GLUE_UPDATETIME" TIMESTAMP(0),

"CHILD_JOBID" VARCHAR(255),

"TRIGGER_STATUS" INT DEFAULT 0 NOT NULL,

"TRIGGER_LAST_TIME" BIGINT DEFAULT 0 NOT NULL,

"TRIGGER_NEXT_TIME" BIGINT DEFAULT 0 NOT NULL,

NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "XXLJOB", CLUSTERBTR) ;

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."ALARM_EMAIL" IS '报警邮件';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."AUTHOR" IS '作者';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."CHILD_JOBID" IS '子任务ID，多个逗号分隔';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."EXECUTOR_BLOCK_STRATEGY" IS '阻塞处理策略';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."EXECUTOR_FAIL_RETRY_COUNT" IS '失败重试次数';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."EXECUTOR_HANDLER" IS '执行器任务handler';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."EXECUTOR_PARAM" IS '执行器任务参数';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."EXECUTOR_ROUTE_STRATEGY" IS '执行器路由策略';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."EXECUTOR_TIMEOUT" IS '任务执行超时时间，单位秒';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."GLUE_REMARK" IS 'GLUE备注';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."GLUE_SOURCE" IS 'GLUE源代码';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."GLUE_TYPE" IS 'GLUE类型';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."GLUE_UPDATETIME" IS 'GLUE更新时间';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."JOB_GROUP" IS '执行器主键ID';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."MISFIRE_STRATEGY" IS '调度过期策略';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."SCHEDULE_CONF" IS '调度配置，值含义取决于调度类型';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."SCHEDULE_TYPE" IS '调度类型';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."TRIGGER_LAST_TIME" IS '上次调度时间';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."TRIGGER_NEXT_TIME" IS '下次调度时间';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_INFO"."TRIGGER_STATUS" IS '调度状态：0-停止，1-运行';

CREATE TABLE "XXLJOB"."XXL_JOB_LOCK"

(

"LOCK_NAME" VARCHAR(50) NOT NULL,

NOT CLUSTER PRIMARY KEY("LOCK_NAME")) STORAGE(ON "XXLJOB", CLUSTERBTR) ;

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOCK"."LOCK_NAME" IS '锁名称';

CREATE TABLE "XXLJOB"."XXL_JOB_LOG"

(

"ID" BIGINT IDENTITY(1, 1) NOT NULL,

"JOB_GROUP" INT NOT NULL,

"JOB_ID" INT NOT NULL,

"EXECUTOR_ADDRESS" VARCHAR(255),

"EXECUTOR_HANDLER" VARCHAR(255),

"EXECUTOR_PARAM" VARCHAR(512),

"EXECUTOR_SHARDING_PARAM" VARCHAR(20),

"EXECUTOR_FAIL_RETRY_COUNT" INT DEFAULT 0 NOT NULL,

"TRIGGER_TIME" TIMESTAMP(0),

"TRIGGER_CODE" INT NOT NULL,

"TRIGGER_MSG" TEXT,

"HANDLE_TIME" TIMESTAMP(0),

"HANDLE_CODE" INT NOT NULL,

"HANDLE_MSG" TEXT,

"ALARM_STATUS" TINYINT DEFAULT 0 NOT NULL,

NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "XXLJOB", CLUSTERBTR) ;

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."ALARM_STATUS" IS '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."EXECUTOR_ADDRESS" IS '执行器地址，本次执行的地址';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."EXECUTOR_FAIL_RETRY_COUNT" IS '失败重试次数';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."EXECUTOR_HANDLER" IS '执行器任务handler';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."EXECUTOR_PARAM" IS '执行器任务参数';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."EXECUTOR_SHARDING_PARAM" IS '执行器任务分片参数，格式如 1/2';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."HANDLE_CODE" IS '执行-状态';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."HANDLE_MSG" IS '执行-日志';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."HANDLE_TIME" IS '执行-时间';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."JOB_GROUP" IS '执行器主键ID';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."JOB_ID" IS '任务，主键ID';

COMMENT ON COLUMN "XXLJOB"."XXL_JOB_LOG"."TRIGGER_CODE" IS '调度-结果';

COMMENT ON COLUMN "XX