Spring Batch tables are not automatically created with multiple datasources using Spring Boot

[Sax388]

I've read spring-projects/spring-boot#33526 and am using

spring:
  batch:
    job:
      # Don't run job on application startup
      enabled: false
    jdbc:
      initialize-schema: always

I've got multiple datasources and one is marked as @Primary.

There's no error message so I don't know to debug it. How can I find out, what I'm missing?

[fmbenhassine]

Have you annotated the datasource to use for Spring Batch with @BatchDataSource? This annotation is deigned for this use case.

[Sax388]

I thought that @BatchDataSource was only needed if you wanted to use the secondary datasource for the Spring Batch tables. I thought the one marked as @Primary would be used by default. Is that a misconception?

[fmbenhassine]

From the Javadocs, I understand that this annotation should be used if there is another datasource marked as primary, which is your case IIUC.

[margi212]

Do not add @EnableBatchProcessiong Annotation when you have disabled job on startup.

[Sax388]

Thank you for the reminder that this topic was still open. I don't use the annotation @EnableBatchProcessing.

[fmbenhassine]

Adding @EnableBatchProcessiong in fact disables the batch auto-configuration in Spring Boot (including meta-data tables creation), see https://github.com/spring-projects/spring-boot/wiki/Spring-Boot-3.0-Migration-Guide#enablebatchprocessing-is-now-discouraged.

[fmbenhassine]

The Batch meta-data table creation is a Spring Boot feature, not a Spring Batch feature. So this question is rather for Spring Boot, but no problem I think I answered it above.

If you have further questions about the Batch support in Spring Boot, please ask in the Spring Boot project and cc me, and I will be happy to help there.