mysql8.0.13配置activiti自动生成表

1.pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.bc</groupId>
  <artifactId>bcactiviti</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>bcactiviti</name>
  <url>http://maven.apache.org</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>

  <dependencies>
    <!-- 引入工作流引擎以及所需要的jar包 -->
      <dependency>
           <groupId>org.activiti</groupId>
           <artifactId>activiti-engine</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>org.activiti</groupId>
           <artifactId>activiti-spring</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>org.activiti</groupId>
           <artifactId>activiti-bpmn-model</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>org.activiti</groupId>
           <artifactId>activiti-bpmn-converter</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>org.activiti</groupId>
           <artifactId>activiti-json-converter</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>org.activiti</groupId>
           <artifactId>activiti-bpmn-layout</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>org.activiti.cloud</groupId>
           <artifactId>activiti-cloud-services-api</artifactId>
           <version>7.0.0.Beta1</version>
       </dependency>

       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>8.0.13</version>
       </dependency>

       <dependency>
           <groupId>junit</groupId>
           <artifactId>junit</artifactId>
           <version>4.12</version>
       </dependency>

       <!-- log start -->
       <dependency>
           <groupId>log4j</groupId>
           <artifactId>log4j</artifactId>
           <version>1.2.17</version>
       </dependency>
       <dependency>
           <groupId>org.slf4j</groupId>
           <artifactId>slf4j-api</artifactId>
           <version>1.7.28</version>
       </dependency>
       <dependency>
           <groupId>org.slf4j</groupId>
           <artifactId>slf4j-log4j12</artifactId>
           <version>1.7.12</version>
       </dependency>
       <!-- log end -->

       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.4.5</version>
       </dependency>

       <dependency>
           <groupId>commons-dbcp</groupId>
           <artifactId>commons-dbcp</artifactId>
           <version>1.4</version>
       </dependency>

       <!--文件读写-->
       <dependency>
           <groupId>commons-io</groupId>
           <artifactId>commons-io</artifactId>
           <version>2.6</version>
       </dependency>
    </dependencies>
    <repositories>
        <repository>
            <id>alfresco</id>
            <name>Activiti Releases</name>
            <url>https://artifacts.alfresco.com/nexus/content/repositories/activiti-releases/</url>
            <releases>
                <enabled>true</enabled>
            </releases>
        </repository>
    </repositories>
</project>

2.activiti.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans.xsd">


<bean class=" org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration" id="processEngineConfiguration">
<!-- 配置数据库连接 -->
<property value="com.mysql.jdbc.Driver" name="jdbcDriver"/>
<property value="jdbc:mysql://localhost:3306/activiti?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8" name="jdbcUrl"/>
<property value="root" name="jdbcUsername"/>
<property value="root" name="jdbcPassword"/>
<!-- 建表策略 没有表,自动创建-->
<property value="true" name="databaseSchemaUpdate"/>
</bean>  
</beans>

3.log4j.propertis

log4j.rootLogger=WARN, stdout, R
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
# Pattern to output the caller's file name and line number.
#log4j.appender.stdout.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n
# Print the date in ISO 8601 format
log4j.appender.stdout.layout.ConversionPattern=%d [%t] %-5p %c - %m%n
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=example.log
log4j.appender.R.MaxFileSize=100KB
# Keep one backup file
log4j.appender.R.MaxBackupIndex=1
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n
# Print only messages of level WARN or above in the package com.foo.
log4j.logger.com.foo=WARN

4.测试类

public class ActivitiTest {
	@Test
	public void testGenTable() {
		// 1创建ProcessEngineConfiguration对象
		ProcessEngineConfiguration configuration = ProcessEngineConfiguration
				.createProcessEngineConfigurationFromResource("activiti.cfg.xml");
		// 2创建ProcessEngine对象
		ProcessEngine processEngine = configuration.buildProcessEngine();
		// 3输出processEngine对象
		System.out.println(processEngine);
	}
}