Spring Boot+Gradle集成jBPM启动报错：H2未初始化TASK表

1. 必须手动提供persistence.xml #

jBPM依赖JPA实现持久化，不会自动生成persistence.xml到类路径，你需要手动创建该文件，路径为src/main/resources/META-INF/persistence.xml，用来配置JPA实体扫描、数据库连接和表初始化策略。

2. 适配H2的persistence.xml示例 #

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1"
             xmlns="http://xmlns.jcp.org/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">

    <persistence-unit name="org.jbpm.persistence.unit" transaction-type="JTA">
        <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
        <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
        <class>org.drools.persistence.info.SessionInfo</class>
        <class>org.drools.persistence.info.WorkItemInfo</class>
        <class>org.jbpm.process.audit.ProcessInstanceLog</class>
        <class>org.jbpm.process.audit.NodeInstanceLog</class>
        <class>org.jbpm.process.audit.VariableInstanceLog</class>
        <class>org.jbpm.task.api.model.User</class>
        <class>org.jbpm.task.api.model.Group</class>
        <class>org.jbpm.task.Task</class>
        <class>org.jbpm.task.Deadline</class>

        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
            <property name="hibernate.connection.driver_class" value="org.h2.Driver"/>
            <property name="hibernate.connection.url" value="jdbc:h2:mem:jbpm;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE"/>
            <property name="hibernate.connection.username" value="sa"/>
            <property name="hibernate.connection.password" value=""/>
            <!-- 开发环境用create自动建表，生产环境建议用update -->
            <property name="hibernate.hbm2ddl.auto" value="create"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
            <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossStandAloneJtaPlatform"/>
        </properties>
    </persistence-unit>
</persistence>

3. Gradle依赖检查 #

确保build.gradle中包含必要的依赖项：

dependencies {
    // jBPM Spring Boot基础 starter
    implementation 'org.jbpm:jbpm-spring-boot-starter-basic:7.59.0.Final'
    // jBPM持久化核心依赖
    implementation 'org.jbpm:jbpm-persistence-jpa:7.59.0.Final'
    // H2数据库驱动
    runtimeOnly 'com.h2database:h2'
    // Hibernate核心依赖
    implementation 'org.hibernate:hibernate-core:5.6.15.Final'
}

4. 额外配置注意事项 #

• 若依赖Spring Boot的自动配置，需避免其JPA配置覆盖jBPM的表初始化逻辑，可在application.properties中添加：

  spring.jpa.hibernate.ddl-auto=none
  

• 启动后查看日志，确认Hibernate是否输出建表SQL语句。若未输出，检查persistence.xml是否放在正确的META-INF路径下，确保该文件被加载到类路径中。

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