使用mp的分页插件时,开启二级缓存,查询报错 Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
### SQL: SELECt COUNT(*) FROM eam_ass_class s RIGHT JOIN eam_ass_class m ON s.pid = m.ass_cl_cde RIGHT JOIN (SELECt t.ass_cl_cde AS l_class, t.ass_cl_nm AS l_class_na FROM eam_ass_class t WHERe t.pid = '0' AND t.`status` = '1') l ON m.pid = l.l_class WHERe s.`status` = '1' AND m.`status` = '1' ### Cause: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ... 88 common frames omitted Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
猜测可能是查询到的数据数据总数没有找到对应接收实体,所以报错,暂时的解决办法是创建page对象时,声明不查询总数,第四个参数--false
Pagepage = new Page<>(pageNum, pageSize,0L,false);
至于使用分页插件并且查询总数时,如何使用二级缓存还没有找到方法,仅于此记录一下



