oracle自动创建表格,flowable oracle 自动建表

最近新的流程引擎选型，最终决定使用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如下，

org.springframework.boot

spring-boot-starter-data-jdbc

org.springframework.boot

spring-boot-starter-web

org.mybatis.spring.boot

mybatis-spring-boot-starter

2.1.3

org.flowable

flowable-spring-boot-starter

6.5.0

com.alibaba

druid

1.1.21

com.oracle.ojdbc

ojdbc8

19.3.0.0

org.projectlombok

lombok

true

org.springframework.boot

spring-boot-starter-test

test

org.junit.vintage

junit-vintage-engine