异常：Error: executeQueryForObject returned too many results. 解决方法

最新推荐文章于 2025-05-10 16:01:33 发布

守护_潇潇

最新推荐文章于 2025-05-10 16:01:33 发布

阅读量2.9w

点赞数 1

CC 4.0 BY-SA版权

分类专栏： MySQL数据库 java

本文链接：https://blog.csdn.net/laixiaobailing/article/details/39157221

java 同时被 2 个专栏收录

12 篇文章

订阅专栏

MySQL数据库

4 篇文章

订阅专栏

本文探讨了在使用executeQueryForObject方法时遇到返回多条记录的问题及解决方案。该方法预期返回单个对象，若结果集包含多条记录则会抛出异常。文章建议采用executeForObjectList或queryForList来处理多条记录的情况。

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

Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
	at com.alibaba.cobar.client.CobarSqlMapClientTemplate.execute(CobarSqlMapClientTemplate.java:154)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
	at com.alibaba.cobar.client.CobarSqlMapClientTemplate.queryForObject(CobarSqlMapClientTemplate.java:643)
	at com.alibaba.cobar.client.CobarSqlMapClientTemplate.queryForObject(CobarSqlMapClientTemplate.java:663)
	at com.inspur.dc.image.impl.PhotoTimeLineDomain.getAllPhotoTimeLine(PhotoTimeLineDomain.java:31)
	... 13 more
Caused by: java.sql.SQLException: Error: executeQueryForObject returned too many results.
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:124)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
	... 18 more

QueryForObject方法返回的是一个对象，如果有多个对象的话，就会报异常。
如果有多条返回结果，不应该用executeQueryForObject，应该用executeForObjectList或者queryForList。
returned too many results说的是返回的值多于一个了，executeQueryForObject要求只返回一个值。