Springboot2.0+mybtaisplus3.3.1+acticiti6.0版本冲突
今天在搭建系统框架时想把activiti整合到项目里面,使用的是activiti6.0,pom文件加入依赖,更新maven
<!--activiti-->
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-engine</artifactId>
<version>6.0.0</version>
</dependency>
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-spring</artifactId>
<version>6.0.0</version>
</dependency>
启动项目报错:
***************************
APPLICATION FAILED TO START
***************************
Description:
An attempt was made to call a method that does not exist. The attempt was made from the following location:
com.baomidou.mybatisplus.core.MybatisMapperAnnotationBuilder.getLanguageDriver(MybatisMapperAnnotationBuilder.java:369)
The following method did not exist:
com.baomidou.mybatisplus.core.MybatisConfiguration.getLanguageDriver(Ljava/lang/Class;)Lorg/apache/ibatis/scripting/LanguageDriver;
The method's class, com.baomidou.mybatisplus.core.MybatisConfiguration, is available from the following locations:
jar:file:/D:/mavencupe/repository/com/baomidou/mybatis-plus-core/3.3.1/mybatis-plus-core-3.3.1.jar!/com/baomidou/mybatisplus/core/MybatisConfiguration.class
It was loaded from the following location:
file:/D:/mavencupe/repository/com/baomidou/mybatis-plus-core/3.3.1/mybatis-plus-core-3.3.1.jar
Action:
Correct the classpath of your application so that it contains a single, compatible version of com.baomidou.mybatisplus.core.MybatisConfiguration
很明显能看到是mybatis-plus-core-3.3.1.jar这个版本的问题,由于之前有搭过框架整合成功过,所有看之前的项目使用的版本是2.3.0,是可以正常启动也不会报错的,但我这个项目由于使用了3.3.1的一些类导致一切换很多类就报错
解决方案:添加activiti的对mabatis的依赖:
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-engine</artifactId>
<version>6.0.0</version>
<exclusions>
<exclusion>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.activiti</groupId>
<artifactId>activiti-spring</artifactId>
<version>6.0.0</version>
</dependency>
启动项目还是报错,创建activiti的表失败
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'test.ACT_GE_PROPERTY' doesn't exist
### The error may exist in org/activiti/db/mapping/entity/Property.xml
### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
### The error occurred while setting parameters
### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
### Cause: java.sql.SQLSyntaxErrorException: Table 'test.ACT_GE_PROPERTY' doesn't exist
在链接数据库url最后面加上&nullCatalogMeansCurrent=true
当nullCatalogMeansCurrent为false时,mysql驱动会遍历当前链接的所有表,如果nullCatalogMeansCurrent为true,则使用指定的数据库来执行查询语句,不会遍历
说明一下:mysql-connector-java在低版本默认是true,高版本是false,我用的mysql是8.0的所以设置为true,降版本到5也是也可的,
至此,问题解决