flowable oracle 自动建表

最新推荐文章于 2024-07-21 14:59:01 发布

编程者说

最新推荐文章于 2024-07-21 14:59:01 发布

阅读量1.8k

点赞数 1

文章标签： flowable

本文链接：https://blog.csdn.net/shipfei_csdn/article/details/107605627

版权

最近新的流程引擎选型，最终决定使用flowable，建表的时候会有些坑，mark下。

import org.flowable.engine.ProcessEngine;
import org.flowable.engine.ProcessEngineConfiguration;
import org.flowable.engine.impl.cfg.StandaloneProcessEngineConfiguration;

/**
 *
 */
public class InitCreateTable {

    public static void main(String[] args) {
        ProcessEngineConfiguration cfg = new StandaloneProcessEngineConfiguration();
        cfg.setJdbcDriver("oracle.jdbc.driver.OracleDriver");
        cfg.setJdbcUrl("jdbc:oracle:thin:@xx.xx.xx.xx:1521:orcl");
        cfg.setJdbcUsername("myflowable");
        cfg.setJdbcPassword("123456");
        cfg.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);

        cfg.setDatabaseSchema("myflowable");
        //cfg.setDatabaseTablePrefix("myflowable");
        ProcessEngine processEngine = cfg.buildProcessEngine();
    }
}

工程使用的是springboot，引入的pom如下，

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>

        <!--flowable工作流依赖-->
        <dependency>
            <groupId>org.flowable</groupId>
            <artifactId>flowable-spring-boot-starter</artifactId>
            <version>6.5.0</version>
        </dependency>
        <!-- druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.21</version>
        </dependency>
        <!-- oracle -->
        <dependency>
            <groupId>com.oracle.ojdbc</groupId>
            <artifactId>ojdbc8</artifactId>
            <version>19.3.0.0</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>