Mybatis出现Caused by: net.sf.jsqlparser.parser.ParseException: ....异常

今天在开发项目中遇到了一个奇怪的异常,记录一下把!

异常信息如下(截取了主要的部分)

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "TOP" "top "" at line 17, column 21. Was expecting one of:     "DO" ...     "ANY" ...     "KEY" ...     "PERCENT" ...     "END" ...     "OPEN" ...     "TABLE" ...     "XML" ...     "VALUE"

解决办法

前人用的pageHelper分页插件,版本低了点,所以升级了一下分页插件的版本,问题就解决了

旧的依赖
<!-- 分页插件pagehelper -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.2</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
            <version>1.2.3</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>
新的依赖
<!-- 分页插件pagehelper -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.2.1</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
posted @ 2022-11-19 19:52  我也有梦想呀  阅读(507)  评论(0编辑  收藏  举报