activiti创建数据库

---

数据库

---

activiti创建数据库有三种方式，但是在实际开中，一般都是默认配置。
而且为了操作方便，一般activiti数据库与项目数据库都会进行分开管理。

 @Override
    public boolean createtableByXml() {
        /**
         * 创建数据库的三种方式
         * 1：指定xml
         * 2： 默认xml（activiti.cfg.xml）
         * 3:不需要xml
            public void createTable(){
                ProcessEngineConfiguration configuration = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();
                configuration.setJdbcDriver("com.mysql.jdbc.Driver");
                configuration.setJdbcUrl("jdbc:mysql://192.168.2.163:3306/activiti?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull");
                configuration.setJdbcUsername("root");
                configuration.setJdbcPassword("root");
                configuration.setDatabaseSchema(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);
                ProcessEngine processEngine = configuration.buildProcessEngine();

            }
         */
        ProcessEngineConfiguration engineConfiguration = ProcessEngineConfiguration
            //1:指定xml
            .createProcessEngineConfigurationFromResource("gms/spring-activiti.xml");
            //2:默认xml
            // .createProcessEngineConfigurationFromResourceDefault();
            engineConfiguration.buildProcessEngine();
        LOGGER.info("创建成功");
        return true;
    }

---

jdbc.properties

---

driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://192.168.2.163:3306/gmsdb?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
jdbcUrlActi=jdbc:mysql://192.168.2.163:3306/activiti?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
username=root
password=root


initialSize=0
maxActive=20
maxIdle=20
minIdle=1
maxWait=60000

github地址：https://github.com/wsylp/gms.git