Shulou(Shulou.com)06/02 Report--

This article shows you what spring batch table sentences are, which are concise and easy to understand, which can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

/ * @ see https://spring.io/guides/gs/batch-processing/ * / @ Configuration@EnableBatchProcessingpublic class BatchConfiguration {...-- https://www.cnblogs.com/ealenxie/p/9647703.html-- do not edit this file-- BATCH JOB instance table contains all information related to aJobInstance-- JOB ID is assigned by batch_job_seq-- JOB name, consistent with spring configuration-- MD5 encoding of job parameters by JOB KEY, precisely because of the existence of this field If the same job runs successfully the first time, the second run throws a JobInstanceAlreadyCompleteException exception. 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)) ENGINE=InnoDB The BATCH_JOB_EXECUTION table contains all the information related to the JobExecution object CREATE TABLE BATCH_JOB_EXECUTION (JOB_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY, VERSION BIGINT, JOB_INSTANCE_ID BIGINT NOT NULL, CREATE_TIME DATETIME NOT NULL, START_TIME DATETIME DEFAULT NULL, END_TIME DATETIME DEFAULT NULL, STATUS VARCHAR (10), EXIT_CODE VARCHAR (2500), EXIT_MESSAGE VARCHAR (2500), LAST_UPDATED DATETIME JOB_CONFIGURATION_LOCATION VARCHAR (2500) NULL, constraint JOB_INST_EXEC_FK foreign key (JOB_INSTANCE_ID) references BATCH_JOB_INSTANCE (JOB_INSTANCE_ID)) ENGINE=InnoDB This table contains all the information related to the JobParameters object 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 DATETIME 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)) ENGINE=InnoDB This table contains all the information related to the StepExecution object 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 DATETIME NOT NULL, END_TIME DATETIME 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 DATETIME, constraint JOB_EXEC_STEP_FK foreign key (JOB_EXECUTION_ID) references BATCH_JOB_EXECUTION (JOB_EXECUTION_ID)) ENGINE=InnoDB This BATCH_STEP_EXECUTION_CONTEXT table contains all the information about ExecutionContext related to Step 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)) ENGINE=InnoDB This table contains all the information about ExecutionContext related to Job CREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (JOB_EXECUTION_ID BIGINT NOT NULL 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)) ENGINE=InnoDB CREATE TABLE BATCH_STEP_EXECUTION_SEQ (ID BIGINT NOT NULL, UNIQUE_KEY CHAR (1) NOT NULL, constraint UNIQUE_KEY_UN unique (UNIQUE_KEY)) ENGINE=InnoDB;INSERT INTO BATCH_STEP_EXECUTION_SEQ (ID, UNIQUE_KEY) select * from (select 0 as ID,'0' as UNIQUE_KEY) as tmp where not exists (select * from BATCH_STEP_EXECUTION_SEQ) CREATE TABLE BATCH_JOB_EXECUTION_SEQ (ID BIGINT NOT NULL, UNIQUE_KEY CHAR (1) NOT NULL, constraint UNIQUE_KEY_UN unique (UNIQUE_KEY)) ENGINE=InnoDB;INSERT INTO BATCH_JOB_EXECUTION_SEQ (ID, UNIQUE_KEY) select * from (select 0 as ID,'0' as UNIQUE_KEY) as tmp where not exists (select * from BATCH_JOB_EXECUTION_SEQ) CREATE TABLE BATCH_JOB_SEQ (ID BIGINT NOT NULL, UNIQUE_KEY CHAR (1) NOT NULL, constraint UNIQUE_KEY_UN unique (UNIQUE_KEY)) ENGINE=InnoDB;INSERT INTO BATCH_JOB_SEQ (ID, UNIQUE_KEY) select * from (select 0 as ID,'0' as UNIQUE_KEY) as tmp where not exists (select * from BATCH_JOB_SEQ);-- hsqldbDROP TABLE people IF EXISTS CREATE TABLE people (person_id BIGINT IDENTITY NOT NULL PRIMARY KEY, first_name VARCHAR (20), last_name VARCHAR (20));-- mysql cannot have IDENTITY-- DROP TABLE IF EXISTS `people` -- CREATE TABLE `people` (--`people bigint (20) NOT NULL AUTO_INCREMENT,-- `first_ name` varchar (20) COLLATE utf8_bin DEFAULT NULL,-- `last_ name` varchar (20) COLLATE utf8_bin DEFAULT NULL,-- PRIMARY KEY (`person_ id`) / *! 50100 TABLESPACE `innodb_ system` * / ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin # mysql configuration spring.datasource.url=jdbc:mysql://132.120.2.134:3300/motor?useUnicode=true&characterEncoding=utf-8spring.datasource.username=motorspring.datasource.password=#spring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver org.hsqldb hsqldb mysql mysql-connector-java What is the above content of runtime? what are the construction table sentences of spring batch? Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.