Spring+xxl-job+oracle

最新推荐文章于 2025-07-15 13:35:29 发布

原创

最新推荐文章于 2025-07-15 13:35:29 发布 · 808 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

一、xxl-job

1.1 下载xxl-job

下载地址：xxl-job

1.2 配置xxl-job

1.2.1 配置数据库：

打开xxl-job-admin下的resources文件夹下的application.properties

其他配置：

修改端口server.port

1.2.2 执行数据库脚本：

打开doc文件-->db-->table_xxl_job.sql。由于源码只有mysql版的脚本。故附上oracle版脚本：

--drop table XXL_JOB_GROUP;
create table XXL_JOB_GROUP
(
    ID            NUMBER not null,
    APP_NAME      VARCHAR2(150) not null,
    TITLE         VARCHAR2(50) not null,
    ADDRESS_TYPE  NUMBER not null,
    ADDRESS_LIST  CLOB,
    UPDATE_TIME   DATE
);
comment on table XXL_JOB_GROUP
 is '执行器信息表';
comment on column XXL_JOB_GROUP.ID
 is 'id';
comment on column XXL_JOB_GROUP.APP_NAME
 is '执行器AppName';
comment on column XXL_JOB_GROUP.TITLE
 is '执行器名称';
comment on column XXL_JOB_GROUP.ADDRESS_TYPE
 is '执行器地址类型：0=自动注册、1=手动录入';
comment on column XXL_JOB_GROUP.ADDRESS_LIST
 is '执行器地址列表，多地址逗号分隔';
comment on column XXL_JOB_GROUP.UPDATE_TIME
 is '';
create index IDX_JOB_GROUP_APP_NAME on XXL_JOB_GROUP(APP_NAME) ;
alter table XXL_JOB_GROUP add constraint PK_XXL_JOB_GROUP primary key (ID)  ;

--drop table XXL_JOB_INFO;
create table XXL_JOB_INFO
(
    ID                        NUMBER not null,
    JOB_GROUP                 NUMBER not null,
    JOB_DESC                  VARCHAR2(500) not null,
    ADD_TIME                  DATE,
    UPDATE_TIME               DATE,
    AUTHOR                    VARCHAR2(500),
    ALARM_EMAIL               VARCHAR2(500),
    SCHEDULE_TYPE             VARCHAR2(50),
    SCHEDULE_CONF             VARCHAR2(128),
    MISFIRE_STRATEGY          VARCHAR2(50),
    EXECUTOR_ROUTE_STRATEGY   VARCHAR2(150),
    EXECUTOR_HANDLER          VARCHAR2(500),
    EXECUTOR_PARAM            VARCHAR2(1000),
    EXECUTOR_BLOCK_STRATEGY   VARCHAR2(150),
    EXECUTOR_TIMEOUT          NUMBER not null,
    EXECUTOR_FAIL_RETRY_COUNT NUMBER not null,
    GLUE_TYPE                 VARCHAR2(150) not null,
    GLUE_SOURCE               CLOB,
    GLUE_REMARK               VARCHAR2(128),
    GLUE_UPDATETIME           DATE,
    CHILD_JOBID               VARCHAR2(500),
    TRIGGER_STATUS            NUMBER not null,
    TRIGGER_LAST_TIME         NUMBER not null,
    TRIGGER_NEXT_TIME         NUMBER not null
) ;
comment on table XXL_JOB_INFO
 is '调度信息表';
comment on column XXL_JOB_INFO.SCHEDULE_CONF
 is '调度配置，值含义取决于调度类型';
comment on column XXL_JOB_INFO.EXECUTOR_HANDLER
 is '执行器任务handler';
comment on column XXL_JOB_INFO.EXECUTOR_PARAM
 is '执行器任务参数';
comment on column XXL_JOB_INFO.EXECUTOR_BLOCK_STRATEGY
 is '阻塞处理策略';
comment on column XXL_JOB_INFO.EXECUTOR_TIMEOUT
 is '任务执行超时时间，单位秒';
comment on column XXL_JOB_INFO.EXECUTOR_FAIL_RETRY_COUNT
 is '失败重试次数';
comment on column XXL_JOB_INFO.GLUE_TYPE
 is 'GLUE类型';
comment on column XXL_JOB_INFO.GLUE_SOURCE
 is 'GLUE源代码';
comment on column XXL_JOB_INFO.GLUE_REMARK
 is 'GLUE备注';
comment on column XXL_JOB_INFO.GLUE_UPDATETIME
 is 'GLUE更新时间';
comment on column XXL_JOB_INFO.CHILD_JOBID
 is '子任务ID，多个逗号分隔';
comment on column XXL_JOB_INFO.TRIGGER_STATUS
 is '调度状态：0-停止，1-运行';
comment on column XXL_JOB_INFO.TRIGGER_LAST_TIME
 is '上次