I am getting error Table 'test.batch_job_instance' doesn't exist

Question

I am new to Spring Batch. I have configured my job with inmemoryrepository. But still, it seems it is using DB to persist job Metadata. My spring batch Configuration is :

@Configuration
public class BatchConfiguration {
    
    
    @Autowired
    private StepBuilderFactory stepBuilderFactory;
    
    @Autowired
    private JobBuilderFactory jobBuilder;
    
    @Bean
    public JobLauncher jobLauncher() throws Exception {
        SimpleJobLauncher job =new SimpleJobLauncher();
        job.setJobRepository(getJobRepo());
        job.afterPropertiesSet();
        return job;
    }
    
    
    @Bean
    public PlatformTransactionManager getTransactionManager() {
        return new ResourcelessTransactionManager();
    }

    @Bean
    public JobRepository getJobRepo() throws Exception {
        return new MapJobRepositoryFactoryBean(getTransactionManager()).getObject();
    }
    

    
    
    @Bean
    public Step step1(JdbcBatchItemWriter<Person> writer) throws Exception {
        return stepBuilderFactory.get("step1")
            .<Person, Person> chunk(10)
            .reader(reader())
            .processor(processor())
            .writer(writer).repository(getJobRepo())
            .build();
    }
    
     @Bean
    public Job job( @Qualifier("step1") Step step1) throws Exception {
        return jobBuilder.get("myJob").start(step1).repository(getJobRepo()).build();
    }

}

How to resolve above issue?

Answer 1

If you are using Sprint boot a simple property in your application.properties will solve the issue spring.batch.initialize-schema=ALWAYS

Answer 2

If You are using Spring 3.0, remove @EnableBatchProcessing annotation.

Answer 3

For a non-Spring Boot setup:

---

This error shows up when a datasource bean is declared in the batch configuration. To workaround the problem I added an embedded datasource, since I didn't want to create those tables in the application database:

@Bean
public DataSource mysqlDataSource() {
  // create your application datasource here
}

@Bean
@Primary
public DataSource batchEmbeddedDatasource() {
    // in memory datasource required by spring batch
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    return builder.setType(EmbeddedDatabaseType.H2)
            .addScript("classpath:schema-drop-h2.sql")
            .addScript("classpath:schema-h2.sql")
            .build();
}

The initialization scripts can be found inside the spring-batch-core-xxx.jar under org.springframework.batch.core package.
Note I used an in-memory database but the solution is valid also for other database systems.

Answer 4

Those who face the same problem with MySql database in CentOS(Most Unix based systems).

Table names are case-sensitive in Linux. Setting lower_case_table_names=1 has solved the problem.

Find official document here

Answer 5

For those using versions greater then spring-boot 2.5 this worked inside of application.properties

spring.batch.jdbc.initialize-schema = ALWAYS

Answer 6

This solved my case:

spring.batch.jdbc.initialize-schema=ALWAYS

Answer 7

It worked for me:

spring.batch.jdbc.initialize-schema=ALWAYS

I am using spring 3.x.x and spring batch 5.0.x