成功解决 org.mybatis.spring.MyBatisSystemException问题!!

  1.   1 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter "couId" not found. Available parameters are [1, 0, param1, param2]
  2.   2     at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
  3.   3     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
  4.   4     at com.sun.proxy.$Proxy15.selectList(Unknown Source)
  5.   5     at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:194)
  6.   6     at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:114)
  7.   7     at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
  8.   8     at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
  9.   9     at com.sun.proxy.$Proxy17.getSCBycouAndcla(Unknown Source)
  10. 10     at cn.springmvc.serviceiml.SortCourseServiceIml.addSCs(Unknown Source)
  11. 11     at cn.springmvc.controller.SortCourseController.leadinSCs(Unknown Source)
  12. 12     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  13. 13     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  14. 14     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  15. 15     at java.lang.reflect.Method.invoke(Method.java:606)
  16. 16     at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
  17. 17     at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
  18. 18     at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
  19. 19     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
  20. 20     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
  21. 21     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
  22. 22     at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
  23. 23     at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
  24. 24     at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
  25. 25     at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  26. 26     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  27. 27     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  28. 28     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  29. 29     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  30. 30     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  31. 31     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  32. 32     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  33. 33     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  34. 34     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  35. 35     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
  36. 36     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  37. 37     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  38. 38     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  39. 39     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  40. 40     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
  41. 41     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  42. 42     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)
  43. 43     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1083)
  44. 44     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:640)
  45. 45     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  46. 46     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  47. 47     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  48. 48     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  49. 49     at java.lang.Thread.run(Thread.java:744)
  50. 50 Caused by: org.apache.ibatis.binding.BindingException: Parameter "couId" not found. Available parameters are [1, 0, param1, param2]
  51. 51     at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:160)
  52. 52     at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:41)
  53. 53     at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113)
  54. 54     at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:72)
  55. 55     at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:77)
  56. 56     at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:58)
  57. 57     at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:71)
  58. 58     at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
  59. 59     at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
  60. 60     at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
  61. 61     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
  62. 62     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
  63. 63     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
  64. 64     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
  65. 65     at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
  66. 66     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  67. 67     at java.lang.reflect.Method.invoke(Method.java:606)
  68. 68     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
  69. 69     ... 46 more
  70. 70 十月 15, 2017 11:35:33 上午 org.apache.catalina.core.StandardWrapperValve invoke
  71. 71 严重: Servlet.service() for servlet [spring] in context with path [/studentleader] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter "couId" not found. Available parameters are [1, 0, param1, param2]] with root cause
  72. 72 org.apache.ibatis.binding.BindingException: Parameter "couId" not found. Available parameters are [1, 0, param1, param2]
  73. 73     at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:160)
  74. 74     at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:41)
  75. 75     at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113)
  76. 76     at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:72)
  77. 77     at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:77)
  78. 78     at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:58)
  79. 79     at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:71)
  80. 80     at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
  81. 81     at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
  82. 82     at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
  83. 83     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
  84. 84     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
  85. 85     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
  86. 86     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
  87. 87     at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
  88. 88     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  89. 89     at java.lang.reflect.Method.invoke(Method.java:606)
  90. 90     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
  91. 91     at com.sun.proxy.$Proxy15.selectList(Unknown Source)
  92. 92     at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:194)
  93. 93     at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:114)
  94. 94     at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
  95. 95     at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
  96. 96     at com.sun.proxy.$Proxy17.getSCBycouAndcla(Unknown Source)
  97. 97     at cn.springmvc.serviceiml.SortCourseServiceIml.addSCs(Unknown Source)
  98. 98     at cn.springmvc.controller.SortCourseController.leadinSCs(Unknown Source)
  99. 99     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  100. 100     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  101. 101     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  102. 102     at java.lang.reflect.Method.invoke(Method.java:606)
  103. 103     at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
  104. 104     at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
  105. 105     at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
  106. 106     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
  107. 107     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
  108. 108     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
  109. 109     at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
  110. 110     at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
  111. 111     at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
  112. 112     at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  113. 113     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  114. 114     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  115. 115     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  116. 116     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  117. 117     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  118. 118     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  119. 119     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  120. 120     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  121. 121     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  122. 122     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
  123. 123     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  124. 124     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  125. 125     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  126. 126     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  127. 127     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
  128. 128     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  129. 129     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442)
  130. 130     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1083)
  131. 131     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:640)
  132. 132     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  133. 133     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  134. 134     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  135. 135     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  136. 136     at java.lang.Thread.run(Thread.java:744)
复制代码



今天写项目,写到多个参数从数据库取数据时,一直报这个错,经过查找资料等,终于成功解决,解决前代码为
DAO层
修改前:
 

  1. public  List<SortCourse> getSC(String couId,String classname);  
复制代码



mapper.xml
修改前:
 

  1. <select id="getSC" parameterType="String" resultType="SortCourse">
  2.     select * from sortcourse where couId=#{couId} and classname=#{classname}
  3. </select>
复制代码



因为mapper配置文件中parameterType为String,只能接收一个参数,故将parameterType属性去掉
则修改第一步:将mapper.xml中将parameterType属性去掉
修改后:
 

  1. <select id="getSC"  resultType="SortCourse">
  2.     select * from sortcourse where couId=#{couId} and classname=#{classname}
  3. </select>
复制代码



修改第二步:将DAO成代码修改为
修改后:
 

  1. public  List<SortCourse> getSC(@Param("couId")String couId,@Param("classname")String classname);
复制代码



再导入Param包
问题成功解决!!

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
`org.mybatis.spring.MyBatisSystemException` 是 MyBatis-Spring 框架中抛出的一个异常,它通常表示在使用 MyBatis 进行数据库操作时遇到了严重的问题,可能是配置错误、数据源问题、SQL执行失败或者是 SpringMyBatis 的集成不当等原因导致的。解决这类异常通常需要按照以下步骤进行: 1. **检查日志**:查看详细的异常堆栈信息,这会在日志文件(如 logback.xml 或 log4j.properties)中,通常会提供关于异常发生的具体位置和原因的线索。 2. **检查配置**:确保 MyBatis 的配置(mybatis-config.xml)正确无误,包括数据源(DataSource)、SqlSessionFactory 的创建、Mapper 的扫描路径等。 3. **Spring 配置**:确认 SpringMyBatis 的整合配置是否正确,比如 MapperScannerConfigurer 或 sqlSessionTemplate 等。 4. **SQL问题**:检查 SQL 语句是否有语法错误,参数绑定是否正确,以及动态查询中的条件表达式是否能够正确解析。 5. **事务管理**:确认事务的开启、提交和回滚是否在预期范围内,特别是在分布式环境下,分布式事务配置可能会影响 MyBatis 的执行。 6. **依赖版本**:确认使用的 MyBatisSpring 和其他依赖库的版本是否兼容,有时候版本冲突也可能引发此类问题。 7. **逐步调试**:如果以上都无法确定问题,可以尝试编写一些测试用例,通过单元测试或集成测试逐步定位问题。 如果遇到具体的异常实例,提供具体的异常信息将有助于给出更精准的解决方案。
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值