springbatch 数据库脚本

Spring Batch 的作用是实现批处理任务，其中涉及到对数据库的读写操作。因此，在使用 Spring Batch 时，需要先创建相应的数据库表来存储批处理任务的信息。以下是 Spring Batch 的数据库脚本：

CREATE TABLE BATCH_JOB_INSTANCE  (
    JOB_INSTANCE_ID BIGINT  NOT NULL PRIMARY KEY ,
    VERSION         BIGINT,
    JOB_NAME        VARCHAR(100) NOT NULL,
    JOB_KEY         VARCHAR(32) NOT NULL,
    constraint JOB_INST_UN unique (JOB_NAME, JOB_KEY)
) ;

CREATE TABLE BATCH_JOB_EXECUTION  (
    JOB_EXECUTION_ID BIGINT  NOT NULL PRIMARY KEY ,
    VERSION          BIGINT  NOT NULL,
    JOB_INSTANCE_ID  BIGINT  NOT NULL,
    CREATE_TIME      TIMESTAMP NOT NULL,
    START_TIME       TIMESTAMP DEFAULT NULL ,
    END_TIME         TIMESTAMP DEFAULT NULL ,
    STATUS           VARCHAR(10) ,
    EXIT_CODE        VARCHAR(2500) ,
    EXIT_MESSAGE     VARCHAR(2500) ,
    LAST_UPDATED     TIMESTAMP NOT NULL,
    JOB_CONFIGURATION_LOCATION VARCHAR(2500) NULL,
    constraint JOB_INST_EXEC_FK foreign key (JOB_INSTANCE_ID)
      references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
) ;

CREATE TABLE BATCH_STEP_EXECUTION (
    STEP_EXECUTION_ID BIGINT  NOT NULL PRIMARY KEY ,
    VERSION          BIGINT NOT NULL,
    STEP_NAME        VARCHAR(100) NOT NULL,
    JOB_EXECUTION_ID BIGINT NOT NULL,
    START_TIME       TIMESTAMP NOT NULL ,
    END_TIME         TIMESTAMP DEFAULT NULL ,
    STATUS           VARCHAR(10) ,
    COMMIT_COUNT     BIGINT ,
    READ_COUNT       BIGINT ,
    FILTER_COUNT     BIGINT ,
    WRITE_COUNT      BIGINT ,
    READ_SKIP_COUNT  BIGINT ,
    WRITE_SKIP_COUNT BIGINT ,
    PROCESS_SKIP_COUNT BIGINT ,
    ROLLBACK_COUNT   BIGINT ,
    EXIT_CODE        VARCHAR(2500) ,
    EXIT_MESSAGE     VARCHAR(2500) ,
    LAST_UPDATED     TIMESTAMP NOT NULL,
    constraint JOB_EXEC_STEP_FK foreign key (JOB_EXECUTION_ID)
      references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) ;

CREATE TABLE BATCH_JOB_EXECUTION_PARAMS  (
    JOB_EXECUTION_ID BIGINT NOT NULL ,
    TYPE_CD         VARCHAR(6) NOT NULL ,
    KEY_NAME        VARCHAR(100) NOT NULL ,
    STRING_VAL      VARCHAR(250) ,
    DATE_VAL        TIMESTAMP DEFAULT NULL ,
    LONG_VAL        BIGINT ,
    DOUBLE_VAL      DOUBLE PRECISION ,
    IDENTIFYING     CHAR(1) NOT NULL ,
    constraint JOB_EXEC_PARAMS_FK foreign key (JOB_EXECUTION_ID)
      references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) ;

CREATE TABLE BATCH_STEP_EXECUTION_CONTEXT  (
    STEP_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY,
    SHORT_CONTEXT VARCHAR(2500) NOT NULL,
    SERIALIZED_CONTEXT TEXT ,
    constraint STEP_EXEC_CTX_FK foreign key (STEP_EXECUTION_ID)
      references BATCH_STEP_EXECUTION(STEP_EXECUTION_ID)
) ;

CREATE TABLE BATCH_JOB_EXECUTION_CONTEXT  (
    JOB_EXECUTION_ID PRIMARY KEY,
    SHORT_CONTEXT VARCHAR(2500) NOT NULL,
    SERIALIZED_CONTEXT TEXT ,
    constraint JOB_EXEC_CTX_FK foreign key (JOB_EXECUTION_ID)
      references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) ;

CREATE TABLE BATCH_STEP_EXECUTION_SEQ (
    ID BIGINT NOT NULL,
    constraint STEP_EXECUTION_SEQ_PK primary key (ID)
) ;

INSERT INTO BATCH_STEP_EXECUTION_SEQ values(0);

CREATE TABLE BATCH_JOB_SEQ (
    ID BIGINT NOT NULL,
    constraint JOB_SEQ_PK primary key (ID)
) ;

INSERT INTO BATCH_JOB_SEQ values(0);

CREATE TABLE BATCH_JOB_EXECUTION_SEQ (
    ID BIGINT NOT NULL,
    constraint JOB_EXECUTION_SEQ_PK primary key (ID)
) ;

INSERT INTO BATCH_JOB_EXECUTION_SEQ values(0);

CREATE TABLE BATCH_JOB_PARAMS  (
    JOB_INSTANCE_ID BIGINT NOT NULL ,
    TYPE_CD         VARCHAR(6) NOT NULL ,
    KEY_NAME        VARCHAR(100) NOT NULL ,
    STRING_VAL      VARCHAR(250) ,
    DATE_VAL        TIMESTAMP DEFAULT NULL ,
    LONG_VAL        BIGINT ,
    DOUBLE_VAL      DOUBLE PRECISION ,
    IDENTIFYING     CHAR(1) NOT NULL ,
    constraint JOB_INST_PARAMS_FK foreign key (JOB_INSTANCE_ID)
      references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
) ;

这些脚本将创建 Spring Batch 中使用的所有表。在使用 Spring Batch 进行开发时，可以将这些脚本直接在数据库中执行，以创建相应的表。