解决Caused by: net.sf.jsqlparser.parser.ParseException: Encountered “ “(“ “( ““ at line 10, column 42.

最新推荐文章于 2024-07-26 15:17:50 发布

灰太狼_cxh

最新推荐文章于 2024-07-26 15:17:50 发布

阅读量7.2k

点赞数 1

分类专栏： bug错误相册文章标签： sql linq java

本文链接：https://blog.csdn.net/weixin_39220472/article/details/123485257

版权

在运行mybatis查询时遇到了net.sf.jsqlparser.parser.ParseException异常，问题源于Mybatis分页插件不支持IF函数。查询SQL在第10行第42列出现错误。解决办法是避免使用IF函数或者寻找替代方案。

摘要由CSDN通过智能技术生成

解决Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 10, column 42.

运行mybatis查询sql时报错异常：

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 10, column 42.
Was expecting one of:
    "AS" ...
    "DO" ...
    "ANY" ...
    "KEY" ...
    "PERCENT" ...
    "END" ...
    "INTO" ...
    "FROM" ...
    "OPEN" ...
    "TABLE" ...
    "WHERE" ...
    "FOR" ...
    "XML" ...
    "UNION" ...
    "GROUP" ...
    "ORDER" ...
    "VALUE" ...
    "HAVING" ...
    "INSERT" ...
    "VALUES" ...
    "REPLACE" ...
    "TRUNCATE" ...
    "INTERSECT" ...
    "CAST" ...
    "EXCEPT" ...
    "MINUS" ...
    "OVER" ...
    "PA