异常：SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];...

最新推荐文章于 2022-07-29 21:57:25 发布
最新推荐文章于 2022-07-29 21:57:25 发布 · 2.1k 阅读 · 0
文章标签：

#java

本文讨论了Spring框架中使用MyBatis进行数据库操作时遇到的一个具体问题，即SQLMapClient在执行查询时返回了多个结果，导致执行失败。详细分析了错误原因并提供了解决方案。

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

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 org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271) at com.webapp.maintain.schedule.dao.ScheduleDao.query(ScheduleDao.java:41) at com.webapp.maintain.schedule.service.ScheduleService.query(ScheduleService.java:46) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy16.query(Unknown Source) at com.webapp.maintain.schedule.action.ScheduleUpdateAction.query(ScheduleUpdateAction.java:26) at com.webapp.struct.module.action.Action.doGet(Action.java:43) at com.webapp.struct.module.action.EmpowermentAction.doGet(EmpowermentAction.java:27) at com.webapp.struct.module.action.EmpowermentDoubleAction.doGet(EmpowermentDoubleAction.java:20) at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at com.webapp.struct.module.permissions.PermissionsManager.checkQueryPermissions(PermissionsManager.java:71) at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy3.doGet(Unknown Source) at com.webapp.main.WebApp.doGet(WebApp.java:108) at com.webapp.control.action.ActionProcess.execute(ActionProcess.java:24) at com.webapp.main.WebApp.service(WebApp.java:101) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) 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) ... 55 more

iteye_1803
关注
出现 nested exception is java.sql.SQLException: 无效的列类型 的解决方法
码农研究僧的博客
06-29 3101
SQL state [99999]; error code [17004]; 无效的列类型; nested exception is java.sql.SQLException: 无效的列类型
全网最详细的org.springframework.jdbc.UncategorizedSQLException的多种解决方法
念兮为美
02-02 1万+
全网最详细的org.springframework.jdbc.UncategorizedSQLException的多种解决方法，比如语法错误，字段名称对不上，字段类型不一致，数据表的限制，字符集的限制等。
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; 异常解决
热门推荐
我的世界我的梦
08-28 4万+
在使用Spring+Ibatis集成的时候，使用如下方式配置复杂类型的时候，总是报异常 resultMap class="order" id="result">       result property="orderid" column="OrderId"/>       result property="customer" column="Customer"/>       res
uncategorized SQLException； SQL state [null]； error code [0]； sql injection violation, syntax error
bsegebr的博客
07-29 1万+
本次主要记录自己在项目中编写SQL的时候遇到的异常uncategorizedSQLException;SQLstate[null];errorcode[0];sqlinjectionviolation,syntaxerrorERROR.pos117,line2,column111…1。
14.mybatis:uncategorized SQLException for SQL []； SQL state [null]； error code [0]； Error； 报错解决；
qq_37992410的博客
06-14 1万+
mybatis与构造函数；uncategorized SQLException for SQL []; SQL state [null]; error code [0];
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
Preserve
11-26 1万+
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in ibatis.xml. --- The
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException; SQL state [null]; error code [0];
04-27
这个错误信息是关于Spring JDBC模块的，它表示一个未分类的SQL异常，具体的原因需要查看异常堆栈信息中的SQL语句、SQL状态码和错误代码等内容来确定。可能的原因包括但不限于：SQL语句语法错误、数据库连接异常、...
2023-06-07 11:49:45 ERROR [XssSqlConfigUpdateExecutorThread-1] c.b.i.c.s.i.ServiceBase - org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException; SQL state [null]; error code [-4470]; --- The error occurred while applying a parameter map. --- Check the XSSC01.query-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: com.ibm.db2.jcc.am.SqlException: [jcc][10120][10943][4.21.29] 操作无效：已关闭 statement。 ERRORCODE=-4470, SQLSTATE=null; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the XSSC01.query-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: com.ibm.db2.jcc.am.SqlException: [jcc][10120][10943][4.21.29] 操作无效：已关闭 statement。 ERRORCODE=-4470, SQLSTATE=null
06-08
这段错误信息显示了一个 SQL 操作的异常。根据错误信息，可能存在以下问题： 1. SQL 操作使用了一个已关闭的 statement。这可能是由于连接关闭、事务提交或回滚后导致的。 2. SQL 操作中的参数映射存在问题。可能...
spring ibatis mysql_spring整合ibatis和mysql出现的错误?
06-06
4. org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory ...
Spring事务问题 - 大数据clob插入需要事务
qingchun1987_303的专栏
12-07 3301
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];    --- The error occurred in sqlmap_mysql/bpm/bpml
mysql数据库UNCATEGORIZED SQLEXCEPTION FOR SQL []; SQL STATE [NULL]; ERROR CODE [0]
weixin_43855290的博客
05-05 1万+
— The error occurred in com/jxc/dao/impl/maps/T_report.xml. — The error occurred while applying a result map. — Check the T_report.selectT_reportAll-AutoResultMap. — The error happened while setting a...
uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error; nested exception is
corleone_4ever的博客
03-24 3万+
mybatis报错报这个错 百度一番,都是说Integer类型写成了int,不能传null 我这个报错原因比较坑 实体类型是String,数据库类型是int 但是实体类的值是数字,按理是可以自动转换成数字入库的,但是我用的是国产达梦数据库 经过调试,确定是这个问题 总结:代码规范严谨的重要性,不可洒脱,最好保证实体类和数据库字段类型一致 ...
Mybatis uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection viola
zlp1992的专栏
11-18 1万+
今天用mybatis写了个查询代码，发现怎么样都报错，提示： uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: EOF : select * from\n \n\t\tinbound_detail\n\t \n where i...
错误提示：SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17...
weixin_30802171的博客
03-10 1303
这个问题已经折腾我两天了，今天终于在一位同事(zhangwei)的帮助下解决了。 1.起初没有创建序列s_log，因此需要在Oracle补上s_log序列。 <!-- 增加 日志 --> <insert id="logSave" parameterClass="com.reportcenter.sys.dto.OperateLogDto"> I...
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null];
ALL TECHNOLOGIES ARE CLOUDS
08-04 729
网上解决方案 1.起初没有创建序列s_log，因此需要在Oracle补上s_log序列。 &lt;!-- 增加 日志 --&gt;  &lt;insert id="logSave"   parameterClass="com.reportcenter.sys.dto.OperateLogDto"&gt;   INSERT INTO   T_LOG(C_AUTOID,USRCDE,USR...
异常：SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
上班搞IT，下班搞ITF。
02-07 1万+
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many resu
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值