场景:在搭建MyBatis-Plus配置租户时遇到的异常
完整错误:
java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select. PlainSelect.getGroupBy()Lnet/sf/jsqlparser/statement/select/GroupByElement;
解决方法:jar包的版本不对,我一开始使用了 pagehelper-spring-boot-starter 包,换了很多版本都不行,最后换成了 pagehelper 的jar包
<!--<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.0</version>
</dependency>-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.11</version>
</dependency>
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>3.1</version>
</dependency>
后面又出现分页失效问题,气傻掉了!!!
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
<exclusions>
<exclusion>
<artifactId>mybatis-spring</artifactId>
<groupId>org.mybatis</groupId>
</exclusion>
<exclusion>
<artifactId>mybatis</artifactId>
<groupId>org.mybatis</groupId>
</exclusion>
</exclusions>
</dependency>
因为整合的是 MyBatis-Plus 所以要排除掉 MyBatis 的包