【Activiti】PersistenceException，MySQLSyntaxErrorException，order by RES.ID_ asc LIMIT 1 OFFSET 0

最新推荐文章于 2023-02-02 13:54:31 发布
最新推荐文章于 2023-02-02 13:54:31 发布
阅读量868 收藏
点赞数
分类专栏： 【Activiti】 【报错】 【MySQL】 文章标签： activiti mysql pom
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/River_Continent/article/details/104023301
版权

一、问题

1.1、环境
电脑环境：Windows 10；
开发工具：Eclipse 4.6.3；
数据库环境：Oracle 11g；
JDK环境: Jdk1.8；
Maven环境：Maven3.5.0；
GIT版本：Version 2.48.02;
Docker版本：Server Version: 19.03.3
1.2、问题
启动activiti测试时，报错，报错内容如下：

"C:\Program Files\Java\jdk1.8.0_92\bin\java" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\softWareInstalled\work\IntelliJ IDEA 2017.2.4\lib\idea_rt.jar=51807:C:\softWareInstalled\work\IntelliJ IDEA 2017.2.4\bin" -Dfile.encoding=UTF-8 -classpath "C:\softWareInstalled\work\IntelliJ IDEA 2017.2.4\lib\idea_rt.jar;C:\softWareInstalled\work\IntelliJ IDEA 2017.2.4\plugins\junit\lib\junit-rt.jar;C:\softWareInstalled\work\IntelliJ IDEA 2017.2.4\plugins\junit\lib\junit5-rt.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_92\jre\lib\rt.jar;C:\projects\jxdx\jxdx-admin\target\test-classes;C:\projects\jxdx\jxdx-admin\target\classes;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-aop\1.3.6.RELEASE\spring-boot-starter-aop-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter\1.3.6.RELEASE\spring-boot-starter-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot\1.3.6.RELEASE\spring-boot-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\1.3.6.RELEASE\spring-boot-autoconfigure-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-logging\1.3.6.RELEASE\spring-boot-starter-logging-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\ch\qos\logback\logback-classic\1.1.7\logback-classic-1.1.7.jar;C:\Users\Auther\.m2\repository\ch\qos\logback\logback-core\1.1.7\logback-core-1.1.7.jar;C:\Users\Auther\.m2\repository\org\slf4j\jul-to-slf4j\1.7.21\jul-to-slf4j-1.7.21.jar;C:\Users\Auther\.m2\repository\org\slf4j\log4j-over-slf4j\1.7.21\log4j-over-slf4j-1.7.21.jar;C:\Users\Auther\.m2\repository\org\yaml\snakeyaml\1.16\snakeyaml-1.16.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-aop\4.2.7.RELEASE\spring-aop-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Users\Auther\.m2\repository\org\aspectj\aspectjweaver\1.8.9\aspectjweaver-1.8.9.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-cache\1.3.6.RELEASE\spring-boot-starter-cache-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-context\4.2.7.RELEASE\spring-context-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-expression\4.2.7.RELEASE\spring-expression-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-context-support\4.2.7.RELEASE\spring-context-support-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-validation\1.3.6.RELEASE\spring-boot-starter-validation-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\8.0.36\tomcat-embed-el-8.0.36.jar;C:\Users\Auther\.m2\repository\org\hibernate\hibernate-validator\5.2.4.Final\hibernate-validator-5.2.4.Final.jar;C:\Users\Auther\.m2\repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;C:\Users\Auther\.m2\repository\org\jboss\logging\jboss-logging\3.3.0.Final\jboss-logging-3.3.0.Final.jar;C:\Users\Auther\.m2\repository\com\fasterxml\classmate\1.1.0\classmate-1.1.0.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-web\1.3.6.RELEASE\spring-boot-starter-web-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\1.3.6.RELEASE\spring-boot-starter-tomcat-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\8.0.36\tomcat-embed-core-8.0.36.jar;C:\Users\Auther\.m2\repository\org\apache\tomcat\embed\tomcat-embed-logging-juli\8.0.36\tomcat-embed-logging-juli-8.0.36.jar;C:\Users\Auther\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.0.36\tomcat-embed-websocket-8.0.36.jar;C:\Users\Auther\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.6.7\jackson-databind-2.6.7.jar;C:\Users\Auther\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.6.7\jackson-annotations-2.6.7.jar;C:\Users\Auther\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.6.7\jackson-core-2.6.7.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-web\4.2.7.RELEASE\spring-web-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-webmvc\4.2.7.RELEASE\spring-webmvc-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\1.3.6.RELEASE\spring-boot-starter-jdbc-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\apache\tomcat\tomcat-jdbc\8.0.36\tomcat-jdbc-8.0.36.jar;C:\Users\Auther\.m2\repository\org\apache\tomcat\tomcat-juli\8.0.36\tomcat-juli-8.0.36.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-jdbc\4.2.7.RELEASE\spring-jdbc-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\session\spring-session\1.0.2.RELEASE\spring-session-1.0.2.RELEASE.jar;C:\Users\Auther\.m2\repository\mysql\mysql-connector-java\5.1.47\mysql-connector-java-5.1.47.jar;C:\projects\jxdx\jxdx-admin\lib\ojdbc14-10.2.0.4.0.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-test\1.3.6.RELEASE\spring-boot-starter-test-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;C:\Users\Auther\.m2\repository\org\objenesis\objenesis\2.1\objenesis-2.1.jar;C:\Users\Auther\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\Auther\.m2\repository\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-core\4.2.7.RELEASE\spring-core-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-test\4.2.7.RELEASE\spring-test-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\com\alibaba\fastjson\1.2.31\fastjson-1.2.31.jar;C:\Users\Auther\.m2\repository\org\apache\httpcomponents\httpclient\4.5.2\httpclient-4.5.2.jar;C:\Users\Auther\.m2\repository\org\apache\httpcomponents\httpcore\4.4.5\httpcore-4.4.5.jar;C:\Users\Auther\.m2\repository\org\jdom\jdom\2.0.2\jdom-2.0.2.jar;C:\Users\Auther\.m2\repository\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;C:\Users\Auther\.m2\repository\xml-apis\xml-apis\1.0.b2\xml-apis-1.0.b2.jar;C:\Users\Auther\.m2\repository\com\alibaba\druid\1.0.22\druid-1.0.22.jar;C:\Program Files\Java\jdk1.8.0_92\lib\jconsole.jar;C:\Program Files\Java\jdk1.8.0_92\lib\tools.jar;C:\Users\Auther\.m2\repository\org\apache\ws\commons\schema\XmlSchema\1.4.7\XmlSchema-1.4.7.jar;C:\Users\Auther\.m2\repository\com\thoughtworks\xstream\xstream\1.4.2\xstream-1.4.2.jar;C:\Users\Auther\.m2\repository\xmlpull\xmlpull\1.1.3.1\xmlpull-1.1.3.1.jar;C:\Users\Auther\.m2\repository\xpp3\xpp3_min\1.1.4c\xpp3_min-1.1.4c.jar;C:\Users\Auther\.m2\repository\org\mybatis\mybatis\3.4.1\mybatis-3.4.1.jar;C:\Users\Auther\.m2\repository\org\mybatis\mybatis-spring\1.3.0\mybatis-spring-1.3.0.jar;C:\Users\Auther\.m2\repository\org\mybatis\generator\mybatis-generator-core\1.3.3\mybatis-generator-core-1.3.3.jar;C:\Users\Auther\.m2\repository\com\github\pagehelper\pagehelper\4.1.6\pagehelper-4.1.6.jar;C:\Users\Auther\.m2\repository\com\github\jsqlparser\jsqlparser\0.9.5\jsqlparser-0.9.5.jar;C:\Users\Auther\.m2\repository\com\aliyun\oss\aliyun-sdk-oss\2.2.3\aliyun-sdk-oss-2.2.3.jar;C:\Users\Auther\.m2\repository\net\sf\json-lib\json-lib\2.4\json-lib-2.4-jdk15.jar;C:\Users\Auther\.m2\repository\commons-lang\commons-lang\2.5\commons-lang-2.5.jar;C:\Users\Auther\.m2\repository\net\sf\ezmorph\ezmorph\1.0.6\ezmorph-1.0.6.jar;C:\Users\Auther\.m2\repository\org\apache\poi\poi\3.9\poi-3.9.jar;C:\Users\Auther\.m2\repository\org\apache\poi\poi-ooxml\3.9\poi-ooxml-3.9.jar;C:\Users\Auther\.m2\repository\org\apache\poi\poi-ooxml-schemas\3.9\poi-ooxml-schemas-3.9.jar;C:\Users\Auther\.m2\repository\org\apache\xmlbeans\xmlbeans\2.3.0\xmlbeans-2.3.0.jar;C:\Users\Auther\.m2\repository\stax\stax-api\1.0.1\stax-api-1.0.1.jar;C:\Users\Auther\.m2\repository\net\sf\jxls\jxls-core\1.0.5\jxls-core-1.0.5.jar;C:\Users\Auther\.m2\repository\commons-logging\commons-logging\1.1.1\commons-logging-1.1.1.jar;C:\Users\Auther\.m2\repository\commons-beanutils\commons-beanutils\1.9.2\commons-beanutils-1.9.2.jar;C:\Users\Auther\.m2\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Users\Auther\.m2\repository\commons-digester\commons-digester\2.1\commons-digester-2.1.jar;C:\Users\Auther\.m2\repository\org\apache\commons\commons-jexl\2.0.1\commons-jexl-2.0.1.jar;C:\Users\Auther\.m2\repository\tk\mybatis\mapper\3.3.8\mapper-3.3.8.jar;C:\Users\Auther\.m2\repository\javax\persistence\persistence-api\1.0\persistence-api-1.0.jar;C:\Users\Auther\.m2\repository\org\apache\commons\commons-lang3\3.4\commons-lang3-3.4.jar;C:\Users\Auther\.m2\repository\com\google\guava\guava\19.0\guava-19.0.jar;C:\Users\Auther\.m2\repository\org\jdom\jdom2\2.0.6\jdom2-2.0.6.jar;C:\Users\Auther\.m2\repository\commons-httpclient\commons-httpclient\3.1\commons-httpclient-3.1.jar;C:\Users\Auther\.m2\repository\commons-codec\commons-codec\1.10\commons-codec-1.10.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-web\1.4.0\shiro-web-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-core\1.4.0\shiro-core-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-lang\1.4.0\shiro-lang-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-crypto-hash\1.4.0\shiro-crypto-hash-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-crypto-core\1.4.0\shiro-crypto-core-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-crypto-cipher\1.4.0\shiro-crypto-cipher-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-config-core\1.4.0\shiro-config-core-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-config-ogdl\1.4.0\shiro-config-ogdl-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-event\1.4.0\shiro-event-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-spring\1.4.0\shiro-spring-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-ehcache\1.4.0\shiro-ehcache-1.4.0.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-cache\1.4.0\shiro-cache-1.4.0.jar;C:\Users\Auther\.m2\repository\net\sf\ehcache\ehcache-core\2.6.11\ehcache-core-2.6.11.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-cas\1.4.0\shiro-cas-1.4.0.jar;C:\Users\Auther\.m2\repository\org\jasig\cas\client\cas-client-core\3.2.2\cas-client-core-3.2.2.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-freemarker\1.3.6.RELEASE\spring-boot-starter-freemarker-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\freemarker\freemarker\2.3.24-incubating\freemarker-2.3.24-incubating.jar;C:\Users\Auther\.m2\repository\net\mingsoft\shiro-freemarker-tags\0.1\shiro-freemarker-tags-0.1.jar;C:\Users\Auther\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\Auther\.m2\repository\com\google\zxing\javase\3.1.0\javase-3.1.0.jar;C:\Users\Auther\.m2\repository\com\google\zxing\core\3.1.0\core-3.1.0.jar;C:\Users\Auther\.m2\repository\org\quartz-scheduler\quartz\2.2.1\quartz-2.2.1.jar;C:\Users\Auther\.m2\repository\c3p0\c3p0\0.9.1.1\c3p0-0.9.1.1.jar;C:\Users\Auther\.m2\repository\org\springframework\integration\spring-integration-mail\4.2.8.RELEASE\spring-integration-mail-4.2.8.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\integration\spring-integration-core\4.2.8.RELEASE\spring-integration-core-4.2.8.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\retry\spring-retry\1.1.3.RELEASE\spring-retry-1.1.3.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-messaging\4.2.7.RELEASE\spring-messaging-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\net\sourceforge\jexcelapi\jxl\2.6.12\jxl-2.6.12.jar;C:\Users\Auther\.m2\repository\com\sun\mail\javax.mail\1.5.5\javax.mail-1.5.5.jar;C:\Users\Auther\.m2\repository\javax\activation\activation\1.1\activation-1.1.jar;C:\Users\Auther\.m2\repository\com\mortennobel\java-image-scaling\0.8.6\java-image-scaling-0.8.6.jar;C:\Users\Auther\.m2\repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-tx\4.2.7.RELEASE\spring-tx-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-all\1.2.4\shiro-all-1.2.4.jar;C:\Users\Auther\.m2\repository\org\apache\shiro\shiro-guice\1.2.4\shiro-guice-1.2.4.jar;C:\Users\Auther\.m2\repository\com\google\inject\guice\3.0\guice-3.0.jar;C:\Users\Auther\.m2\repository\javax\inject\javax.inject\1\javax.inject-1.jar;C:\Users\Auther\.m2\repository\com\google\inject\extensions\guice-multibindings\3.0\guice-multibindings-3.0.jar;C:\Users\Auther\.m2\repository\com\github\penggle\kaptcha\2.3.2\kaptcha-2.3.2.jar;C:\Users\Auther\.m2\repository\com\jhlabs\filters\2.0.235-1\filters-2.0.235-1.jar;C:\Users\Auther\.m2\repository\org\jsoup\jsoup\1.10.2\jsoup-1.10.2.jar;C:\Users\Auther\.m2\repository\io\jsonwebtoken\jjwt\0.7.0\jjwt-0.7.0.jar;C:\Users\Auther\.m2\repository\org\apache\directory\studio\org.apache.commons.io\2.4\org.apache.commons.io-2.4.jar;C:\Users\Auther\.m2\repository\commons-io\commons-io\2.4\commons-io-2.4.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-starter-actuator\1.3.6.RELEASE\spring-boot-starter-actuator-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\springframework\boot\spring-boot-actuator\1.3.6.RELEASE\spring-boot-actuator-1.3.6.RELEASE.jar;C:\Users\Auther\.m2\repository\org\activiti\activiti-engine\5.18.0\activiti-engine-5.18.0.jar;C:\Users\Auther\.m2\repository\org\activiti\activiti-bpmn-converter\5.18.0\activiti-bpmn-converter-5.18.0.jar;C:\Users\Auther\.m2\repository\org\activiti\activiti-bpmn-model\5.18.0\activiti-bpmn-model-5.18.0.jar;C:\Users\Auther\.m2\repository\org\activiti\activiti-process-validation\5.18.0\activiti-process-validation-5.18.0.jar;C:\Users\Auther\.m2\repository\org\activiti\activiti-image-generator\5.18.0\activiti-image-generator-5.18.0.jar;C:\Users\Auther\.m2\repository\org\apache\commons\commons-email\1.4\commons-email-1.4.jar;C:\Users\Auther\.m2\repository\org\springframework\spring-beans\4.2.7.RELEASE\spring-beans-4.2.7.RELEASE.jar;C:\Users\Auther\.m2\repository\joda-time\joda-time\2.8.2\joda-time-2.8.2.jar;C:\Users\Auther\.m2\repository\org\slf4j\slf4j-api\1.7.21\slf4j-api-1.7.21.jar;C:\Users\Auther\.m2\repository\org\slf4j\jcl-over-slf4j\1.7.21\jcl-over-slf4j-1.7.21.jar;C:\Users\Auther\.m2\repository\junit\junit\4.8.2\junit-4.8.2.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.activiti.ActivitiTest2,finishApply
18:05:24.271 [main] INFO org.activiti.engine.ProcessEngines - Initializing process engine using configuration 'file:/C:/projects/jxdx/jxdx-admin/target/classes/activiti.cfg.xml'
18:05:24.277 [main] INFO org.activiti.engine.ProcessEngines - initializing process engine for resource file:/C:/projects/jxdx/jxdx-admin/target/classes/activiti.cfg.xml
18:05:24.478 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding [systemProperties] PropertySource with lowest search precedence
18:05:24.479 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding [systemEnvironment] PropertySource with lowest search precedence
18:05:24.479 [main] DEBUG org.springframework.core.env.StandardEnvironment - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
18:05:24.487 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from InputStream resource [resource loaded through InputStream]
18:05:24.512 [main] DEBUG org.springframework.beans.factory.xml.DefaultDocumentLoader - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
18:05:24.555 [main] DEBUG org.springframework.beans.factory.xml.PluggableSchemaResolver - Loading schema mappings from [META-INF/spring.schemas]
18:05:24.566 [main] DEBUG org.springframework.beans.factory.xml.PluggableSchemaResolver - Loaded schema mappings: {http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/cache/spring-cache-4.2.xsd=org/springframework/cache/config/spring-cache-4.2.xsd, http://www.springframework.org/schema/aop/spring-aop-4.1.xsd=org/springframework/aop/config/spring-aop-4.1.xsd, http://www.springframework.org/schema/context/spring-context-3.1.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd=org/springframework/jdbc/config/spring-jdbc-4.1.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd=org/springframework/web/servlet/config/spring-mvc-4.1.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-4.2.xsd, http://www.springframework.org/schema/aop/spring-aop-3.2.xsd=org/springframework/aop/config/spring-aop-3.2.xsd, http://mybatis.org/schema/mybatis-spring-1.2.xsd=org/mybatis/spring/config/mybatis-spring-1.2.xsd, http://www.springframework.org/schema/lang/spring-lang-4.1.xsd=org/springframework/scripting/config/spring-lang-4.1.xsd, http://www.springframework.org/schema/context/spring-context-4.0.xsd=org/springframework/context/config/spring-context-4.0.xsd, http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd=org/springframework/web/servlet/config/spring-mvc-3.2.xsd, http://www.springframework.org/schema/beans/spring-beans-4.2.xsd=org/springframework/beans/factory/xml/spring-beans-4.2.xsd, http://www.springframework.org/schema/tool/spring-tool-4.1.xsd=org/springframework/beans/factory/xml/spring-tool-4.1.xsd, http://www.springframework.org/schema/lang/spring-lang-3.2.xsd=org/springframework/scripting/config/spring-lang-3.2.xsd, http://www.springframework.org/schema/cache/spring-cache-3.2.xsd=org/springframework/cache/config/spring-cache-3.2.xsd, http://www.springframework.org/schema/jee/spring-jee-4.1.xsd=org/springframework/ejb/config/spring-jee-4.1.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/task/spring-task-4.2.xsd=org/springframework/scheduling/config/spring-task-4.2.xsd, http://www.springframework.org/schema/tool/spring-tool-3.2.xsd=org/springframework/beans/factory/xml/spring-tool-3.2.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-4.2.xsd, http://www.springframework.org/schema/tx/spring-tx-4.2.xsd=org/springframework/transaction/config/spring-tx-4.2.xsd, http://www.springframework.org/schema/cache/spring-cache-4.1.xsd=org/springframework/cache/config/spring-cache-4.1.xsd, http://www.springframework.org/schema/aop/spring-aop-4.0.xsd=org/springframework/aop/config/spring-aop-4.0.xsd, http://www.springframework.org/schema/jee/spring-jee-3.2.xsd=org/springframework/ejb/config/spring-jee-3.2.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd=org/springframework/jdbc/config/spring-jdbc-4.0.xsd, http://www.springframework.org/schema/integration/spring-integration.xsd=org/springframework/integration/config/xml/spring-integration-4.2.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd=org/springframework/web/servlet/config/spring-mvc-4.0.xsd, http://www.springframework.org/schema/beans/spring-beans-3.2.xsd=org/springframework/beans/factory/xml/spring-beans-3.2.xsd, http://www.springframework.org/schema/aop/spring-aop-3.1.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang-4.0.xsd=org/springframework/scripting/config/spring-lang-4.0.xsd, http://www.springframework.org/schema/integration/mail/spring-integration-mail.xsd=org/springframework/integration/mail/config/spring-integration-mail-4.2.xsd, http://www.springframework.org/schema/mvc/spring-mvc.xsd=org/springframework/web/servlet/config/spring-mvc-4.2.xsd, http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd=org/springframework/web/servlet/config/spring-mvc-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-4.1.xsd=org/springframework/beans/factory/xml/spring-beans-4.1.xsd, http://www.springframework.org/schema/tool/spring-tool-4.0.xsd=org/springframework/beans/factory/xml/spring-tool-4.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.2.xsd=org/springframework/transaction/config/spring-tx-3.2.xsd, http://www.springframework.org/schema/lang/spring-lang-3.1.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache-3.1.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-4.0.xsd=org/springframework/ejb/config/spring-jee-4.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/task/spring-task-4.1.xsd=org/springframework/scheduling/config/spring-task-4.1.xsd, http://www.springframework.org/schema/tool/spring-tool-3.1.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-4.2.xsd, http://www.springframework.org/schema/tx/spring-tx-4.1.xsd=org/springframework/transaction/config/spring-tx-4.1.xsd, http://www.springframework.org/schema/cache/spring-cache-4.0.xsd=org/springframework/cache/config/spring-cache-4.0.xsd, http://www.springframework.org/schema/jee/spring-jee-3.1.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.springframework.org/schema/util/spring-util-4.2.xsd=org/springframework/beans/factory/xml/spring-util-4.2.xsd, http://www.springframework.org/schema/task/spring-task-3.2.xsd=org/springframework/scheduling/config/spring-task-3.2.xsd, http://www.springframework.org/schema/beans/spring-beans-3.1.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-4.2.xsd, http://www.springframework.org/schema/aop/spring-aop-3.0.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd=org/springframework/web/servlet/config/spring-mvc-3.0.xsd, http://www.springframework.org/schema/beans/spring-beans-4.0.xsd=org/springframework/beans/factory/xml/spring-beans-4.0.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-4.2.xsd, http://www.springframework.org/schema/tx/spring-tx-3.1.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://mybatis.org/schema/mybatis-spring.xsd=org/mybatis/spring/config/mybatis-spring-1.2.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/task/spring-task-4.0.xsd=org/springframework/scheduling/config/spring-task-4.0.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-4.0.xsd=org/springframework/transaction/config/spring-tx-4.0.xsd, http://www.springframework.org/schema/integration/mail/spring-integration-mail-4.2.xsd=org/springframework/integration/mail/config/spring-integration-mail-4.2.xsd, http://www.springframework.org/schema/aop/spring-aop-2.0.xsd=org/springframework/aop/config/spring-aop-2.0.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/util/spring-util-4.1.xsd=org/springframework/beans/factory/xml/spring-util-4.1.xsd, http://www.springframework.org/schema/task/spring-task-3.1.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-4.2.xsd, http://www.springframework.org/schema/aop/spring-aop-2.5.xsd=org/springframework/aop/config/spring-aop-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/util/spring-util-3.2.xsd=org/springframework/beans/factory/xml/spring-util-3.2.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-4.2.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/context/spring-context-4.2.xsd=org/springframework/context/config/spring-context-4.2.xsd, http://www.springframework.org/schema/integration/spring-integration-4.2.xsd=org/springframework/integration/config/xml/spring-integration-4.2.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.springframework.org/schema/util/spring-util-4.0.xsd=org/springframework/beans/factory/xml/spring-util-4.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/aop/spring-aop-4.2.xsd=org/springframework/aop/config/spring-aop-4.2.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-4.2.xsd, http://www.springframework.org/schema/context/spring-context-3.2.xsd=org/springframework/context/config/spring-context-3.2.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-4.2.xsd=org/springframework/jdbc/config/spring-jdbc-4.2.xsd, http://www.springframework.org/schema/util/spring-util-3.1.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd=org/springframework/web/servlet/config/spring-mvc-4.2.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/cache/spring-cache.xsd=org/springframework/cache/config/spring-cache-4.2.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-4.2.xsd, http://www.springframework.org/schema/lang/spring-lang-4.2.xsd=org/springframework/scripting/config/spring-lang-4.2.xsd, http://www.springframework.org/schema/context/spring-context-4.1.xsd=org/springframework/context/config/spring-context-4.1.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd, http://www.springframework.org/schema/tool/spring-tool-4.2.xsd=org/springframework/beans/factory/xml/spring-tool-4.2.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.alibaba.com/schema/stat.xsd=META-INF/stat.xsd, http://www.springframework.org/schema/jee/spring-jee-4.2.xsd=org/springframework/ejb/config/spring-jee-4.2.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd=org/springframework/jdbc/config/spring-jdbc-3.2.xsd, http://www.springframework.org/schema/aop/spring-aop.xsd=org/springframework/aop/config/spring-aop-4.2.xsd}
18:05:24.575 [main] DEBUG org.springframework.beans.factory.xml.PluggableSchemaResolver - Found XML schema [http://www.springframework.org/schema/beans/spring-beans.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-4.2.xsd
18:05:24.637 [main] DEBUG org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader - Loading bean definitions
18:05:24.670 [main] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'processEngineConfiguration'
18:05:24.670 [main] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'processEngineConfiguration'
18:05:24.763 [main] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'processEngineConfiguration' to allow for resolving potential circular references
18:05:24.931 [main] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Finished creating instance of bean 'processEngineConfiguration'
18:05:29.095 [main] DEBUG org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl - initializing datasource to db: jdbc:mysql://localhost:3306/sys?useUnicode=true&characterEncoding=utf8
18:05:29.101 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
18:05:29.163 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - PooledDataSource forcefully closed/removed all connections.
Fri Jan 17 18:05:29 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
18:05:29.681 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Created connection 826865256.
18:05:29.681 [main] DEBUG org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl - database product name: 'MySQL'
18:05:29.681 [main] DEBUG org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl - using database type: mysql
18:05:29.681 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Returned connection 826865256 to pool.
18:05:30.468 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - 

18:05:30.468 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
18:05:30.479 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
18:05:30.479 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Checked out connection 826865256 from pool.
18:05:30.479 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@3148f668]
18:05:30.497 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty - ==>  Preparing: select * from ACT_GE_PROPERTY where NAME_ = ? 
18:05:30.535 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty - ==> Parameters: schema.version(String)
18:05:30.554 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty - <==      Total: 1
18:05:30.560 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - flush summary: 0 insert, 0 update, 0 delete.
18:05:30.560 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - now executing flush...
18:05:30.560 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committing...
18:05:30.561 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - committing the ibatis sql session...
18:05:30.561 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committed...
18:05:30.562 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@3148f668]
18:05:30.562 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@3148f668]
18:05:30.562 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Returned connection 826865256 to pool.
18:05:30.563 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
18:05:30.563 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - 

18:05:30.563 [main] INFO org.activiti.engine.impl.ProcessEngineImpl - ProcessEngine default created
18:05:30.574 [main] INFO org.activiti.engine.ProcessEngines - initialised process engine default
18:05:30.576 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - 

18:05:30.576 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting CompleteTaskCmd --------------------------------------------------------
18:05:30.577 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
18:05:30.577 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Checked out connection 826865256 from pool.
18:05:30.577 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@3148f668]
18:05:30.577 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTask - ==>  Preparing: select * from ACT_RU_TASK where ID_ = ? 
18:05:30.577 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTask - ==> Parameters: 2504(String)
18:05:30.582 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTask - <==      Total: 1
18:05:30.582 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionById - ==>  Preparing: select * from ACT_RE_PROCDEF where ID_ = ? 
18:05:30.582 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionById - ==> Parameters: myProcess_1:1:4(String)
18:05:30.586 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionById - <==      Total: 1
18:05:30.587 [main] DEBUG org.activiti.engine.impl.persistence.entity.DeploymentEntity.selectDeploymentById - ==>  Preparing: select * from ACT_RE_DEPLOYMENT where ID_ = ? 
18:05:30.587 [main] DEBUG org.activiti.engine.impl.persistence.entity.DeploymentEntity.selectDeploymentById - ==> Parameters: 1(String)
18:05:30.588 [main] DEBUG org.activiti.engine.impl.persistence.entity.DeploymentEntity.selectDeploymentById - <==      Total: 1
18:05:30.588 [main] DEBUG org.activiti.engine.impl.bpmn.deployer.BpmnDeployer - Processing deployment null
18:05:30.588 [main] DEBUG org.activiti.engine.impl.persistence.entity.ResourceEntity.selectResourcesByDeploymentId - ==>  Preparing: select * from ACT_GE_BYTEARRAY where DEPLOYMENT_ID_ = ? order by NAME_ asc 
18:05:30.588 [main] DEBUG org.activiti.engine.impl.persistence.entity.ResourceEntity.selectResourcesByDeploymentId - ==> Parameters: 1(String)
18:05:30.594 [main] DEBUG org.activiti.engine.impl.persistence.entity.ResourceEntity.selectResourcesByDeploymentId - <==      Total: 2
18:05:30.594 [main] INFO org.activiti.engine.impl.bpmn.deployer.BpmnDeployer - Processing resource shenqing.bpmn
18:05:30.675 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.ProcessParseHandler - Parsing process myProcess_1
18:05:30.675 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler - Parsing activity _3
18:05:30.707 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler - Parsing activity _4
18:05:30.708 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler - Parsing activity _7
18:05:30.708 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler - Parsing activity _2
18:05:30.710 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler - Parsing activity _9
18:05:30.711 [main] INFO org.activiti.engine.impl.bpmn.deployer.BpmnDeployer - Processing resource shenqing.png
18:05:30.711 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionByDeploymentAndKey - ==>  Preparing: select * from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = ? and KEY_ = ? and (TENANT_ID_ = '' or TENANT_ID_ is null) 
18:05:30.712 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionByDeploymentAndKey - ==> Parameters: 1(String), myProcess_1(String)
18:05:30.714 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionByDeploymentAndKey - <==      Total: 1
18:05:30.715 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTasksByParentTaskId - ==>  Preparing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ? 
18:05:30.715 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTasksByParentTaskId - ==> Parameters: 2504(String)
18:05:30.716 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTasksByParentTaskId - <==      Total: 0
18:05:30.717 [main] DEBUG org.activiti.engine.impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask - ==>  Preparing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ? 
18:05:30.718 [main] DEBUG org.activiti.engine.impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask - ==> Parameters: 2504(String)
18:05:30.720 [main] DEBUG org.activiti.engine.impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask - <==      Total: 0
18:05:30.720 [main] DEBUG org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId - ==>  Preparing: select * from ACT_RU_VARIABLE where TASK_ID_ = ? 
18:05:30.720 [main] DEBUG org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId - ==> Parameters: 2504(String)
18:05:30.722 [main] DEBUG org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId - <==      Total: 0
18:05:30.724 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: AUDIT
18:05:30.725 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance - ==>  Preparing: select * from ACT_HI_TASKINST where ID_ = ? 
18:05:30.725 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance - ==> Parameters: 2504(String)
18:05:30.727 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance - <==      Total: 1
18:05:30.729 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntity.selectExecution - ==>  Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 
18:05:30.729 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntity.selectExecution - ==> Parameters: 2501(String)
18:05:30.731 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntity.selectExecution - <==      Total: 1
18:05:30.732 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTasksByExecutionId - ==>  Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 
18:05:30.732 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTasksByExecutionId - ==> Parameters: 2501(String)
18:05:30.734 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntity.selectTasksByExecutionId - <==      Total: 1
18:05:30.736 [main] DEBUG org.activiti.engine.impl.bpmn.behavior.BpmnActivityBehavior - Leaving activity '_3'
18:05:30.750 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: ACTIVITY
18:05:30.808 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria - ==>  Preparing: select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by order by RES.ID_ asc LIMIT ? OFFSET ? 
18:05:30.808 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria - ==> Parameters: 2501(String), _3(String), 1(Integer), 0(Integer)
18:05:30.824 [main] DEBUG org.activiti.engine.impl.interceptor.CommandContext - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 1 OFFSET 0' at line 19
### The error may exist in org/activiti/db/mapping/entity/HistoricActivityInstance.xml
### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria-Inline
### The error occurred while setting parameters
### SQL: select RES.*            from ACT_HI_ACTINST RES      WHERE  RES.EXECUTION_ID_ = ?                              and RES.ACT_ID_ = ?                                                                 and RES.END_TIME_ is null           order by  order by RES.ID_ asc       LIMIT ? OFFSET ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 1 OFFSET 0' at line 19
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:435)
	at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:426)
	at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:416)
	at org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityManager.findHistoricActivityInstancesByQueryCriteria(HistoricActivityInstanceEntityManager.java:56)
	at org.activiti.engine.impl.HistoricActivityInstanceQueryImpl.executeList(HistoricActivityInstanceQueryImpl.java:68)
	at org.activiti.engine.impl.AbstractQuery.listPage(AbstractQuery.java:151)
	at org.activiti.engine.impl.history.DefaultHistoryManager.findActivityInstance(DefaultHistoryManager.java:291)
	at org.activiti.engine.impl.history.DefaultHistoryManager.recordActivityEnd(DefaultHistoryManager.java:238)
	at org.activiti.engine.impl.history.handler.ActivityInstanceEndHandler.notify(ActivityInstanceEndHandler.java:28)
	at org.activiti.engine.impl.pvm.runtime.AbstractEventAtomicOperation.execute(AbstractEventAtomicOperation.java:42)
	at org.activiti.engine.impl.interceptor.CommandContext.performOperation(CommandContext.java:96)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.performOperationSync(ExecutionEntity.java:633)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.performOperation(ExecutionEntity.java:628)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.take(ExecutionEntity.java:452)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.take(ExecutionEntity.java:430)
	at org.activiti.engine.impl.bpmn.behavior.BpmnActivityBehavior.performOutgoingBehavior(BpmnActivityBehavior.java:140)
	at org.activiti.engine.impl.bpmn.behavior.BpmnActivityBehavior.performDefaultOutgoingBehavior(BpmnActivityBehavior.java:66)
	at org.activiti.engine.impl.bpmn.behavior.FlowNodeActivityBehavior.leave(FlowNodeActivityBehavior.java:44)
	at org.activiti.engine.impl.bpmn.behavior.AbstractBpmnActivityBehavior.leave(AbstractBpmnActivityBehavior.java:47)
	at org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior.signal(UserTaskActivityBehavior.java:165)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.signal(ExecutionEntity.java:409)
	at org.activiti.engine.impl.persistence.entity.TaskEntity.complete(TaskEntity.java:201)
	at org.activiti.engine.impl.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:52)
	at org.activiti.engine.impl.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:24)
	at org.activiti.engine.impl.cmd.NeedsActiveTaskCmd.execute(NeedsActiveTaskCmd.java:59)
	at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
	at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
	at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
	at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:175)
	at com.activiti.ActivitiTest2.finishApply(ActivitiTest2.java:93)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 1 OFFSET 0' at line 19
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy6.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	... 55 common frames omitted
18:05:30.826 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event rolling back...
18:05:30.826 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - rolling back ibatis sql session...
18:05:30.826 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event rolled back...
18:05:30.826 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@3148f668]
18:05:30.826 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@3148f668]
18:05:30.826 [main] DEBUG org.apache.ibatis.datasource.pooled.PooledDataSource - Returned connection 826865256 to pool.
18:05:30.826 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- CompleteTaskCmd finished --------------------------------------------------------
18:05:30.827 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - 


org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 1 OFFSET 0' at line 19
### The error may exist in org/activiti/db/mapping/entity/HistoricActivityInstance.xml
### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria-Inline
### The error occurred while setting parameters
### SQL: select RES.*            from ACT_HI_ACTINST RES      WHERE  RES.EXECUTION_ID_ = ?                              and RES.ACT_ID_ = ?                                                                 and RES.END_TIME_ is null           order by  order by RES.ID_ asc       LIMIT ? OFFSET ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 1 OFFSET 0' at line 19

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:435)
	at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:426)
	at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:416)
	at org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityManager.findHistoricActivityInstancesByQueryCriteria(HistoricActivityInstanceEntityManager.java:56)
	at org.activiti.engine.impl.HistoricActivityInstanceQueryImpl.executeList(HistoricActivityInstanceQueryImpl.java:68)
	at org.activiti.engine.impl.AbstractQuery.listPage(AbstractQuery.java:151)
	at org.activiti.engine.impl.history.DefaultHistoryManager.findActivityInstance(DefaultHistoryManager.java:291)
	at org.activiti.engine.impl.history.DefaultHistoryManager.recordActivityEnd(DefaultHistoryManager.java:238)
	at org.activiti.engine.impl.history.handler.ActivityInstanceEndHandler.notify(ActivityInstanceEndHandler.java:28)
	at org.activiti.engine.impl.pvm.runtime.AbstractEventAtomicOperation.execute(AbstractEventAtomicOperation.java:42)
	at org.activiti.engine.impl.interceptor.CommandContext.performOperation(CommandContext.java:96)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.performOperationSync(ExecutionEntity.java:633)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.performOperation(ExecutionEntity.java:628)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.take(ExecutionEntity.java:452)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.take(ExecutionEntity.java:430)
	at org.activiti.engine.impl.bpmn.behavior.BpmnActivityBehavior.performOutgoingBehavior(BpmnActivityBehavior.java:140)
	at org.activiti.engine.impl.bpmn.behavior.BpmnActivityBehavior.performDefaultOutgoingBehavior(BpmnActivityBehavior.java:66)
	at org.activiti.engine.impl.bpmn.behavior.FlowNodeActivityBehavior.leave(FlowNodeActivityBehavior.java:44)
	at org.activiti.engine.impl.bpmn.behavior.AbstractBpmnActivityBehavior.leave(AbstractBpmnActivityBehavior.java:47)
	at org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior.signal(UserTaskActivityBehavior.java:165)
	at org.activiti.engine.impl.persistence.entity.ExecutionEntity.signal(ExecutionEntity.java:409)
	at org.activiti.engine.impl.persistence.entity.TaskEntity.complete(TaskEntity.java:201)
	at org.activiti.engine.impl.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:52)
	at org.activiti.engine.impl.cmd.CompleteTaskCmd.execute(CompleteTaskCmd.java:24)
	at org.activiti.engine.impl.cmd.NeedsActiveTaskCmd.execute(NeedsActiveTaskCmd.java:59)
	at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
	at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
	at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:37)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
	at org.activiti.engine.impl.TaskServiceImpl.complete(TaskServiceImpl.java:175)
	at com.activiti.ActivitiTest2.finishApply(ActivitiTest2.java:93)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 1 OFFSET 0' at line 19
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy6.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	... 55 more


Process finished with exit code -1

二、解答

2.1、基本知识；

报错的原因是MySQL的jar包版本和Activiti的jar包版本不兼容；改法有多重，目前试验得到一对比较匹配的POM依赖是：
1、MySQL的pom中的dependency依赖：

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

2、Activiti的pom中的dependency依赖：

		<dependency>
			<groupId>org.activiti</groupId>
			<artifactId>activiti-engine</artifactId>
			<version>5.22.0</version>
		</dependency>

成功~

本篇说明内容完毕；

三、总结

欢迎关注我的
CSDN博客： https://blog.csdn.net/River_Continent
微信公众号：幕桥社区
在这里插入图片描述
知乎：张牧野， https://www.zhihu.com/people/zhang-mu-ye-37-76/activities
简书： https://www.jianshu.com/u/02c0096cbfd3

陶洲川
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
activiti-explorer.rar_Activiti Explorer_Explorer_activiti_activi
07-14
activiti 5.22 explorer的war包
Activiti7.0进阶学习(八):Activiti抛出了PersistenceException
sanding的博客
08-07 873
背景 记录activiti为什么会抛出PersistenceException 过程 操作过程 activiti的审批流程中的某个节点是或签节点。 两个审批人同时进行同意操作（complete） 这个异常是必出现的。 错误信息 2020-08-05 15:20:27.904 ERROR [http-nio-9011-exec-9] o.activiti.engine.impl.interceptor.CommandContext - Error while closing command c
org.apache.struts2.dispatcher.DefaultDispatcherErrorHandler error 严重: Exception occurred during proc
jake_Aaron的博客
11-13 8263
1.Struts2中心控制过滤文件如何配置。 2.过滤路径问题如何解决，请求范围，请求为空？ org.apache.struts2.dispatcher.DefaultDispatcherErrorHandler error 严重: Exception occurred during processing request: null java.lang.NullPointerException
解决分布式事务时报异常
qq_34468174的博客
09-05 541
com.atomikos.icatch.HeurHazardException: Heuristic Exception: 删除Tomcat  bin文件夹下的spring.loglog4j.appender.File.Append=false日志和tmlog.lck、tmlog782.log的文件即可。   转载：http://www.cnblogs.com/zhengQ/p/634326...
Mybatis调用存储过程异常-Non supported SQL92 token at position: 1
热门推荐
piaohai的专栏
02-25 1万+
最近遇到一个奇怪的异常，使用Mybatis调用一个oracle的package时出现一个异常： Mybatis中xxDAO.xml getxxByUserId" statementType="CALLABLE" parameterType="xx.xx.xx.xxInput" resultMap="xxResult"> { call #{output, mode=OUT, j
mybatis:org.apache.ibatis.exceptions.PersistenceException:
qq_37054816的博客
09-08 418
org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manu...
Activiti_OA.rar_activiti_activiti oa_avtiviti oa_oa_流程引擎
07-15
用activiti流程引擎开发的OA功能，全部源码
activiti 5.18.zip_5.18_activiti_activiti7jar_jar_工作流
09-23
activiti-5.18所有jar包，包含了spring包
Activiti 5.14_User_Guide_zh_cn.zip_Activiti5
09-20
org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration:
activiti modeler.zip_activiti_activiti-modeler_java_zip
07-15
activiti modeler 编辑器
mybatis出现PersistenceException:（持久化异常）MysqlSyntaxErrorException:（数据库语法错误异常）
小丁的博客
05-12 2374
总结：出现mysqlsyntaxerrorexception:异常，我们就在映射配置文件中找到mapper标签，检查标签是否符合我们要执行的sql语句，仔细检查mapper标签
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
qq_40181435的博客
04-14 3401
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manu...
mysql error 1231_MySQL_ERROR 1231 (42000) at line XX in file 'file_name' Variable 'time_zone' can't ...
weixin_42515301的博客
01-27 282
类似的错误信息如下ERROR 1231 (42000) at line 10370 in file: '/root/sql/ultrax_170322.dmp': Variable 'time_zone' can't be set to the value of 'NULL'ERROR 1231 (42000) at line 10372 in file: '/root/sql/ultrax_17...
MySQL LIMIT
02-20 660
MySQL LIMIT
SpringBoot整合activiti5-流程部署
m0_37607945的博客
03-26 977
系列文章目录（springboot整合activiti5） 在Activiti中，定义了多种资源，其中*.bpmn和*.bpmn20.xml都是流程定义文件，这两种格式都可以被系统识别并进行解释，但是目前最新版本的Activiti Designer保存的文件都是*.bpmn，而*.png指的是流程定义文件的图片描述，图片内容和流程定义文件描述一致，可以设置在Activiti Designer保存时，同时自动保存一个同名的图片文件。 *.form为表单文件，*.drl为规则定义文件。 Activiti提供了多
activiti部署流程deployment实现源码实现过程
mushuntaosama的博客
10-09 7533
以下是流程部署的实现过程，看了一天源码了解了activiti源码是如何实现的，包括数据数据，了解activiti的架构 //根据bpmn文件部署流程 Deployment deployment = repositoryService.createDeployment().addClasspathResource("diagrams/demo2.bpmn").deploy();  调用顺序 ...
mysql插入数据的时候出错_往mysql中插入数据库发生版本错误的信息
weixin_30923447的博客
01-19 254
java.sql.SQLException: Could not retrieve transation read-only status server at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.SQLError.createSQLExcep...
重谈Handler的内存泄漏
夏夏的博客
02-02 663
在多线程操作中，handler会使用的非常多，但是每次使用handler你有没有考虑内存泄漏的问题。 如果你使用handler进行操作时，你会发现出现以下提示 This Handler class should be static or leaks might occur (anonymous android.os.Handler)这样的提示。翻译： 由于此Handler被声明为内部类，因此可能会阻止外部类被垃圾回收。 如果Handler使用Looper或MessageQueue作为主线程以外的线程，则没
activiti7.1.0.m6版本中， ModelDataJsonConstants.MODEL_NAME、ModelDataJsonConstants.MODEL_REVISION、ModelDataJsonConstants.MODEL_DESCRIPTION，具体值
最新发布
05-22
在 Activiti 7.1.0.m6 版本中，ModelDataJsonConstants 类定义了一些常量，包括： - MODEL_NAME：模型名称，默认值为“新建模型”。 - MODEL_REVISION：模型版本，默认值为1。 - MODEL_DESCRIPTION：模型描述，...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

陶洲川

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值