Spring Boot 3.0.2集成SpringBatch启动内存H2数据库失败

问题说明 #

启动时抛出org.h2.jdbc.JdbcSQLSyntaxErrorException，提示找不到BATCH_JOB_EXECUTION表，核心原因是Spring Batch依赖的元数据表未被初始化。

报错信息 #

org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "BATCH_JOB_EXECUTION" not found (this database is empty); SQL statement:
SELECT JOB_EXECUTION_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, CREATE_TIME, LAST_UPDATED, VERSION from BATCH_JOB_EXECUTION E where JOB_INSTANCE_ID = ? and JOB_EXECUTION_ID in (SELECT max(JOB_EXECUTION_ID) from BATCH_JOB_EXECUTION E2 where E2.JOB_INSTANCE_ID = ?) [42104-214]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:502) ~[h2-2.1.214.jar:2.1.214]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[h2-2.1.214.jar:2.1.214]
    at org.h2.message.DbException.get(DbException.java:223) ~[h2-2.1.214.jar:2.1.214]
    at org.h2.message.DbException.get(DbException.java:199) ~[h2-2.1.214.jar:2.1.214]
    at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8385) ~[h2-2.1.214.jar:2.1.214]
    at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369) ~[h2-2.1.214.jar:2.1.214]
    at org.h2.command.Parser.readTableOrView(Parser.java:8358) ~[h2-2.1.214.jar:2.1.214]

解决方案 #

1. 禁用Hibernate自动DDL #

Hibernate的自动建表逻辑会干扰Spring Batch元数据表的初始化，需在JPA配置中添加ddl-auto: none：

spring:
  jpa:
    database-platform: org.hibernate.dialect.H2Dialect
    hibernate:
      show-sql: true
      ddl-auto: none

2. 确认Spring Batch初始化配置有效性 #

保留spring.batch.jdbc.initialize-schema: always配置，确保Spring Batch每次启动都初始化元数据表：

spring:
  batch:
    jdbc:
      initialize-schema: always
    job:
      enabled: false

3. 检查依赖完整性 #

确保项目依赖中包含Spring Batch和H2的正确版本：

Maven依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-batch</artifactId>
</dependency>
<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>

Gradle依赖

implementation 'org.springframework.boot:spring-boot-starter-batch'
runtimeOnly 'com.h2database:h2'

4. 单数据源场景下的额外验证 #

若项目存在多数据源配置，需显式指定Spring Batch使用的数据源，避免数据源混淆：

spring:
  batch:
    datasource:
      url: jdbc:h2:mem:job-db
      username: sa
      password: password

内容的提问来源于stack exchange，提问作者Wrapper