HTTP Status 500 - Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemExc

最新推荐文章于 2023-03-25 13:10:27 发布
最新推荐文章于 2023-03-25 13:10:27 发布
阅读量8.5k 收藏
点赞数 2
分类专栏： 【Java】
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/haleyliu123/article/details/70159953
版权 
异常描述：
由于设置主表与从表一一对应关系，但是从表添加时添加了多个导致的TooManyResultsException（过多结果集异常）
只要设置外键唯一，或者设置成一对多的关系即可
 

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:168)
	org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:303)
	org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1282)
	org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1037)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:980)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

 

root cause
 

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4
	org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:368)
	com.sun.proxy.$Proxy15.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy23.getByUid(Unknown Source)
	com.lrq.service.serviceImpl.ResumeServiceImpl.getByUid(ResumeServiceImpl.java:46)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	com.sun.proxy.$Proxy24.getByUid(Unknown Source)
	com.lrq.controller.ResumeAction.getResume(ResumeAction.java:56)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:168)
	org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:303)
	org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1282)
	org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1037)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:980)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

 

root cause
 

org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:63)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	com.sun.proxy.$Proxy15.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy23.getByUid(Unknown Source)
	com.lrq.service.serviceImpl.ResumeServiceImpl.getByUid(ResumeServiceImpl.java:46)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	com.sun.proxy.$Proxy24.getByUid(Unknown Source)
	com.lrq.controller.ResumeAction.getResume(ResumeAction.java:56)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:168)
	org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:303)
	org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1282)
	org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1037)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:980)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                

        

        

    

  


    

      

        

            

              
                
                  HaleyLiu123
                
              
            

            

                关注
              
            

        

        

          
      

      

            

                专栏目录
          









                



	

		

			

				
					
浏览器报错如下： HTTP Status 500 - Request processing failed; nested exception is org.mybatis.spring.MyBatis

				
			

			

				

					空空说技术的博客
				

				

					07-02
					
					4万+
					
				

			

		

		

			
				
浏览器报错如下： 
HTTP Status 500 - Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: 

nested exception is org.apache.ibatis.exceptions.PersistenceException:  
type Ex...

			
		

	



                

              
                



	

		

			

				
					
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exc

					
热门推荐

				
			

			

				

					Lele
				

				

					03-06
					
					2万+
					
				

			

		

		

			
				
HTTP Status 500 – Internal Server Error

Type Exception Report

Message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.i...

			
		

	



                


  
              

                


	

		

			

				
					
HTTP Status 500 - Request processing failed； nested exception is org.mybatis.spring.MyBatisSystemExc

					
最新发布

				
			

			

				

					JEREMY的博客
				

				

					03-25
					
					299
					
				

			

		

		

			
				
useSSL设置为false。

			
		

	





	

		

			

				
					
HTTP Status 500 - Request processing failed  nested exception is org.springframework.beans

				
			

			

				

					xue_YTL的博客
				

				

					06-06
					
					955
					
				

			

		

		

			
				
这里写自定义目录标题这程序真的是神奇，我就跟着视频敲居然出现了各种各样的问题**就这样我也搞了几个小时，我真的是人才我笑了
这程序真的是神奇，我就跟着视频敲居然出现了各种各样的问题**就这样我也搞了几个小时，我真的是人才
。
我笑了
exceptionorg.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.beans.Bean

			
		

	



		

			
		



	

		

			

				
					
spring整合mybatis报错 HTTP Status 500 - Request processing failed； nested exception is org.apache.ibatis

				
			

			

				

					China_SYH的博客
				

				

					08-14
					
					626
					
				

			

		

		

			
				
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ssm.mapper.AccountMapper.save
org.apache.ibatis.binding.MapperMethodSqlCommand.<init>(MapperMethod.java:225)org.apache.ibatis.binding.MapperMethod.<init>(Mappe

			
		

	





	

		

			

				
					
消息：Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested

				
			

			

				

					Z2Min_
				

				

					05-10
					
					5538
					
				

			

		

		

			
				
HTTP Status 500 – Internal Server Error
Type 异常报告
消息 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
描述 服务器遇到一个意外的情况，阻止它完成请求。
Exception
org.spr

			
		

	





	

		

			

				
					
http status 500 - request processing failed; nested exception is org.mybatis.spring.mybatissystemexc

				
			

			

				

					03-16
				

			

		

		

			
				
eption: nested exception is org.apache.ibatis.exceptions.PersistenceException:   HTTP状态500 - 请求处理失败；嵌套异常是org.mybatis.spring.MyBatisSystemException：嵌套异常是org.apache.ibatis.exceptions...

			
		

	





	

		

			

				
					
出现500错误 ：Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemExc

				
			

			

				

					weixin_44317900的博客
				

				

					11-20
					
					805
					
				

			

		

		

			
				
最终找到问题
因该改成



			
		

	





	

		

			

				
					
HTTP Status 500 - org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.e...

				
			

			

				

					maxchenBug的博客
				

				

					02-03
					
					682
					
				

			

		

		

			
				
HTTP Status 500 - org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
		
		
		
			HTTP Status 500 - org.mybatis.spring.MyBati...

			
		

	





	

		

			

				
					
Request processing failed； nested exception is org.mybatis.spring.MyBatisSystemException: nested ex

				
			

			

				

					qq_48333276的博客
				

				

					12-23
					
					596
					
				

			

		

		

			
				
这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入
欢迎使用Markdown编辑器
你好！ 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Ma.

			
		

	





	

		

			

				
					
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested ex

				
			

			

				

					Dam_e_的博客
				

				

					12-04
					
					1010
					
				

			

		

		

			
				
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be ...

			
		

	





	

		

			

				
					
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exc...

				
			

			

				

					
				

				

					11-29
					
					2409
					
				

			

		

		

			
				
今天发现一个简单的错误,详细如下:
type Exception report

message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persist...

			
		

	





	

		

			

				
					
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested

				
			

			

				

					lihuagen的博客
				

				

					05-08
					
					8717
					
				

			

		

		

			
				
异常在测试Spring MVC+Mybatis整合时，运行有sql操作的页面报错：错误原因是jdbc.properties的配置文件内后空格，去掉就行，如图：然后再重跑项目就可以了

			
		

	





	

		

			

				
					
【已解决】MyBatis查询数据报错 Request processing failed； nested exception is org.mybatis.spring

				
			

			

				

					m0_67393593的博客
				

				

					08-27
					
					993
					
				

			

		

		

			
				
【代码】【已解决】MyBatis查询数据报错 Request processing failed;

			
		

	





	

		

			

				
					
Request processing failed  nested exception is org.mybatis.spring

				
			

			

				

					weixin_45081813的博客
				

				

					05-08
					
					1万+
					
				

			

		

		

			
				
整合ssm时，当对数据库进行操作时报错：Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘teacher_id’ not found. Available parameters are [arg1, arg0, param1, pa

			
		

	





	

		

			

				
					
错误信息： Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nest...

				
			

			

				

					weixin_30872337的博客
				

				

					04-18
					
					822
					
				

			

		

		

			
				
这个错误主要原因是：数据库的配置出问题，比如写错库名什么的，仔细检查下。





转载于:https://www.cnblogs.com/chaoqi/p/10727167.html

			
		

	



              




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  





	
打赏作者

	

		

		
			
		
		

		

			
HaleyLiu123

			
你的鼓励将是我创作的最大动力

		

	

	

			

	

	

    ¥1
    ¥2
    ¥4
    ¥6
    ¥10
    ¥20
	

	

		

			

				

					扫码支付：¥1
				

				

					

					
					获取中
					

				

				

					
					
					扫码支付
				

			

		

		

			
您的余额不足，请更换扫码支付或充值

			
打赏作者

		

	



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

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

              

            

          

      

      余额充值