org.springframework.dao.IncorrectResultSizeDataAccessException异常的处理

fanship12138

已于 2022-11-24 16:37:43 修改

阅读量3.3k

点赞数 1

CC 4.0 BY-SA版权

文章标签： mysql java

于 2021-07-01 23:00:32 首次发布

本文链接：https://blog.csdn.net/fanship12138/article/details/118399978

本文记录了Java应用中导航栏数据库查询报错，原因为查询语句返回了5条数据而非预期的1条，通过调整查询方法为`query`而非`queryForObject`解决了问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

导航条请求数据库的时候报错，没有数据

java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:564)
	at cn.itcast.travel.web.servlet.BaseServlet.service(BaseServlet.java:37)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at cn.itcast.travel.web.filter.CharchaterFilter.doFilter(CharchaterFilter.java:30)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
	at java.base/java.lang.Thread.run(Thread.java:832)
Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 5
	at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:74)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:492)
	at cn.itcast.travel.dao.impl.CategoryDaoImpl.findAll(CategoryDaoImpl.java:22)
	at cn.itcast.travel.service.impl.CategoryServiceImpl.findAll(CategoryServiceImpl.java:19)
	at cn.itcast.travel.web.servlet.CategoryServlet.findAll(CategoryServlet.java:29)

检查是执行查询语句的方法有问题

queryForObject方法用于查询单个对象

改为query问题解决以后查询所有用query

   String sql="select * from tab_user";
        return (List<Category>) template.queryForObject(sql,new BeanPropertyRowMapper<Category>(Category.class));

记录一下