Caused by: java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.SetOperationList.getSelects()Ljava/util/List;
exception 提问于:2018-06-18
0 0

spring,springmvc,mybaits,mysql分页,union all 出错

Caused by: java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.SetOperationList.getSelects()Ljava/util/List;
    at com.github.pagehelper.parser.SqlParser.processSelectBody(SqlParser.java:181)
    at com.github.pagehelper.parser.SqlParser.processFromItem(SqlParser.java:247)
    at com.github.pagehelper.parser.SqlParser.processPlainSelect(SqlParser.java:203)
    at com.github.pagehelper.parser.SqlParser.processSelectBody(SqlParser.java:173)
    at com.github.pagehelper.parser.SqlParser.getSmartCountSql(SqlParser.java:90)
    at com.github.pagehelper.parser.impl.AbstractParser.getCountSql(AbstractParser.java:141)
    at com.github.pagehelper.sqlsource.PageDynamicSqlSource.getCountBoundSql(PageDynamicSqlSource.java:78)
    at com.github.pagehelper.sqlsource.PageSqlSource.getBoundSql(PageSqlSource.java:71)
    at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:278)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)
    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:497)
    at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
    at com.github.pagehelper.SqlUtil.doProcessPage(SqlUtil.java:478)
    at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:407)
    at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
    at com.github.pagehelper.PageHelper.intercept(PageHelper.java:255)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:60)
  • 所有回答
java_world 回答于:2018-06-19
0 0

不支持union 分页

创建个对应的视图吧

我来回答    Caused by: java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.SetOperationList.getSelects()Ljava/util/List;