Spring Batch DB configuration Sql Scripts

For Database configuration in spring batch we need to run the sql script.

The following are the sql scripts for different databases.

The sql scripts are availalble at spring-batch-core jar. we can simply extract the jar for these scripts

other wise you can simply download from the following location

Spring-Batch-All-Scripts

/* To empty the tables */
DELETE FROM BATCH_STEP_EXECUTION_CONTEXT;
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT;
DELETE FROM BATCH_STEP_EXECUTION;
DELETE FROM BATCH_JOB_EXECUTION;
DELETE FROM BATCH_JOB_PARAMS;
DELETE FROM BATCH_JOB_INSTANCE;

/* To view the data in the tables */
select * from BATCH_JOB_INSTANCE;
select * from BATCH_JOB_PARAMS;
select * from BATCH_JOB_EXECUTION;
select * from BATCH_STEP_EXECUTION;
select * from BATCH_JOB_EXECUTION_CONTEXT;
select * from BATCH_STEP_EXECUTION_CONTEXT;

Tags:Spring batch job scripts for different databases. Spring batch Mysql scripts