Comments (13)
这个错误是由于配置了两个以上分页插件导致的错误。。把你项目中所有和 PageInterceptor 有关的配置都发出来看看。。我现在特别好奇是怎么配置两个的。
from pagehelper-spring-boot.
试试 1.1.0-beta 版本:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.1.0-beta</version>
</dependency>
from pagehelper-spring-boot.
@abel533 确实 你的说明里这样写:
2. 配置拦截器插件
- 在 MyBatis 配置 xml 中配置拦截器插件
- 在 Spring 配置文件中配置拦截器插件
刚接触此插件的小伙伴会以为两个地方都配,结果就报空指针异常了
可以备注一下 配一个地方即可
(顺便膜拜一下大神 插件超好用)
from pagehelper-spring-boot.
我也报同样的错,并没有配置两个分页插件
from pagehelper-spring-boot.
pageHelper 5.0的bug吧,我换回4.2.1就不报错了
from pagehelper-spring-boot.
就是直接按照您的springboot那个demo项目中的三个starter集成的呀。。。没有单独设置PageInterceptor,就是按照https://github.com/abel533/MyBatis-Spring-Boot这个里面复制过去的。。。
我目前全部换成一个一个分开集成的方式。。。就好了。。。没有用starter。。。就瞬间好了。。。
pom参照如下:
org.mybatis.spring.boot mybatis-spring-boot-starter 1.1.1 tk.mybatis mapper-spring-boot-starter 1.0.0 com.github.pagehelper pagehelper-spring-boot-starter 1.0.0from pagehelper-spring-boot.
分开集成和三个集成有什么区别吗?能把有问题的配置贴上了看看吗。
from pagehelper-spring-boot.
额,不明白是哪里的错,出问题的配置是我提交issue的日期时的https://github.com/abel533/MyBatis-Spring-Boot 这个demo里面的配置配的。。。。
from pagehelper-spring-boot.
可能问题是#1里面的大神提出的那样,我大概调试到他出错的那步我就没有深究了,惭愧。。。
from pagehelper-spring-boot.
Yggdrasil 1 1484718265495 INFO DESKTOP-AD5AH36 idcenter 1 No active profile set, falling back to default profiles: default
Yggdrasil 1 1484718277851 INFO DESKTOP-AD5AH36 idcenter 1 Started UserApplication in 17.288 seconds (JVM running for 19.026)
Yggdrasil 1 1484718297054 INFO DESKTOP-AD5AH36 idcenter 1 controller>>>>>>>>>>>>getUserList>>>>>>>>>>>>
Yggdrasil 1 1484718297055 INFO DESKTOP-AD5AH36 idcenter 1 UserServiceImpl>>>>>>>>>>>>getUserList>>>>>>>>>>>>
Yggdrasil 1 1484718297850 DEBUG DESKTOP-AD5AH36 idcenter 1 ==> Preparing: SELECT count(0) FROM (SELECT count(0) FROM users) table_count
Yggdrasil 1 1484718297876 DEBUG DESKTOP-AD5AH36 idcenter 1 ==> Parameters:
Yggdrasil 1 1484718297891 TRACE DESKTOP-AD5AH36 idcenter 1 <== Columns: count(0)
Yggdrasil 1 1484718297891 TRACE DESKTOP-AD5AH36 idcenter 1 <== Row: 1
Yggdrasil 1 1484718297894 DEBUG DESKTOP-AD5AH36 idcenter 1 <== Total: 1
Yggdrasil 1 1484718297896 DEBUG DESKTOP-AD5AH36 idcenter 1 ==> Preparing: SELECT count(0) FROM users LIMIT 2
Yggdrasil 1 1484718297896 DEBUG DESKTOP-AD5AH36 idcenter 1 ==> Parameters:
Yggdrasil 1 1484718297897 TRACE DESKTOP-AD5AH36 idcenter 1 <== Columns: count(0)
Yggdrasil 1 1484718297897 TRACE DESKTOP-AD5AH36 idcenter 1 <== Row: 7
Yggdrasil 1 1484718297897 DEBUG DESKTOP-AD5AH36 idcenter 1 <== Total: 1
2017-01-18 13:44:57.927 ERROR 20852 --- [nio-7878-exec-1] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.lang.NullPointerException
The error may exist in file [E:\JavaWork\Workspaces\GitHub\micro-service-users\target\classes\micro\service\users\mapper\UserMapper.xml]
The error may involve micro.service.users.mapper.UserMapper.getAllList_COUNT
The error occurred while handling results
SQL: SELECT count(0) FROM users LIMIT 2
Cause: java.lang.NullPointerException] with root cause
这个是打印出来的跟踪是这样的也报空指针错误
from pagehelper-spring-boot.
我确实是集成了两个插件,嗯应该是一个插件集成了两次。在bean里加了个plugin在mybatis-config里又加了一遍,就出错了。去掉一个就好了
from pagehelper-spring-boot.
@abel533 你这个是怎么处理的呢?我用了1.0.0的com.github.pagehelper:pagehelper-spring-boot-starter:1.1.0-beta的starter,就好了,没用之前报和上面的错误一模一样
from pagehelper-spring-boot.
pageHelper 5.0的bug吧,我换回4.2.1就不报错了
是不再报错了,但是分页还生效吗?
from pagehelper-spring-boot.
Related Issues (20)
- 在项目中使用热部署,starter中的PageHelperAutoConfiguration会重复添加PageInterceptor
- pom依赖冲突
- 会出现rows有数据但是total的数量等于0的情况 HOT 4
- 大数据量时查询效率的问题
- spring boot3 启动有警告
- pageNum超出totalPages,分页总是返回最后一页的数据 HOT 1
- 依赖引不进来 HOT 2
- 1.4.7依赖有问题 HOT 3
- 关于分页时联表查询count会统计全部行数, 而不是左表行数. HOT 3
- GBase分页会自动把库表连接符冒号:替换成点号. HOT 2
- 通过pagehelper实现较个性化的分页需求 HOT 2
- 第三方依赖建议添加<optional>true</optional> HOT 1
- intellij idea警告try-with-resources HOT 1
- springboot使用1.4.7版本后启动报错 HOT 1
- startPage的orderBy存在字段重复排序问题
- setOrderBy(param.getOrderBy())里面的参数驼峰可以自动转换为下划线吗 HOT 2
- 支持mybatis-plus吗 HOT 4
- 今天从pagehelper.version 1.4.7 升级到 pagehelper.version2.1.0 出现的问题 HOT 9
- 大佬,请问什么时候适配spring boot 3.2呢? HOT 6
- 升级到最新版本后出现PageHelperAutoConfiguration Bad return type HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pagehelper-spring-boot.