java.lang.IllegalArgumentException：未知参数名称：customer

Java 前端之家
前端之家收集整理的这篇文章主要介绍了java.lang.IllegalArgumentException：未知参数名称：customer，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
我正在尝试使用getNamedQuery方法创建一个List,但我得到了这个异常.

这是我的代码

  1. public List<Equip> getEquipsByCustomer(int customer) {
  2.  
  3.     return (List<Equip>) sessionFactory.getCurrentSession()
  4.             .getNamedQuery("getEquipsByCustomer")
  5.             .setParameter("customer",customer)
  6.             .list();
  7. }

以及xml文件中的查询

  1. <sql-query name="getEquipsByCustomer">
  2.     <return class="Equip" alias="equip"/>
  3.     <query-param name="customer" type="int"/>
  4.     SELECT e.* FROM request r
  5.     INNER JOIN equip e ON r.equip_id = e.equip_id
  6.     INNER JOIN customer c ON r.customer_id = c.customer_id
  7.     WHERE c.customer_id = :customer;
  8. </sql-query>

我正在使用另一个getNamedQuery方法,但只有这个得到异常,我找不到我做错了什么.有什么我想念的吗？

完全例外

  1. org.springframework.web.util.NestedServletException: Request processing Failed; nested exception is java.lang.IllegalArgumentException: Unknown parameter name : customer
  2. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:980)
  3. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
  4. javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
  5. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
  6. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  7. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  8. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  9. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  10. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  11. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  12. org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
  13. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  14. org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  15. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  16. org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:112)
  17. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  18. org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
  19. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  20. org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  21. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  22. org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  23. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  24. org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
  25. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  26. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  27. org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  28. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  29. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  30. org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:106)
  31. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  32. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  33. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  34. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  35. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  36.  
  37. java.lang.IllegalArgumentException: Unknown parameter name : customer
  38. org.hibernate.query.internal.QueryParameterBindingsImpl.getBinding(QueryParameterBindingsImpl.java:193)
  39. org.hibernate.query.internal.AbstractProducedQuery.setParameter(AbstractProducedQuery.java:474)
  40. org.hibernate.query.internal.NativeQueryImpl.setParameter(NativeQueryImpl.java:571)
  41. org.hibernate.query.internal.NativeQueryImpl.setParameter(NativeQueryImpl.java:51)
  42. com.cclip.core.equip.EquipRepositoryImpl.getEquipsByCustomer(EquipRepositoryImpl.java:18)
  43. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  44. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  45. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  46. java.lang.reflect.Method.invoke(Unknown Source)
  47. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
  48. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  49. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  50. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  51. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  52. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  53. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  54. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
  55. com.sun.proxy.$Proxy44.getEquipsByCustomer(Unknown Source)
  56. com.cclip.core.equip.EquipServiceImpl.findEquipsByCustomer(EquipServiceImpl.java:37)
  57. com.cclip.mvc.controllers.HomeController.helloWorld(HomeController.java:67)
  58. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  59. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  60. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  61. java.lang.reflect.Method.invoke(Unknown Source)
  62. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  63. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
  64. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  65. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)
  66. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)
  67. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  68. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
  69. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
  70. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
  71. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
  72. javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
  73. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
  74. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  75. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  76. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  77. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  78. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  79. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  80. org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
  81. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  82. org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  83. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  84. org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:112)
  85. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  86. org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
  87. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  88. org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  89. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  90. org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  91. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  92. org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
  93. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  94. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  95. org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  96. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  97. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  98. org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:106)
  99. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  100. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  101. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  102. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  103. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

解决方法

尝试删除;在查询结束时,它实际上是以您的参数名称加入的,最终成为客户;

猜你在找的Java相关文章

ArrayList源码分析
ArrayList简介：ArrayList 的底层是数组队列，相当于动态数组。与 Java 中的数组相比，它的...
java多线程与并发（基础篇）
一、进程与线程 进程：是代码在数据集合上的一次运行活动，是系统进行资源分配和调度的基本...
LinkedList 的实现原理
本文为博客园作者所写：&#160;一寸HUI，个人博客地址：https://www.cnblogs.com/zsql/...
java之面向对象详解
#############java面向对象详解#############1、面向对象基本概念2、类与对象3、类和对象的...
java之异常详解
一、什么是异常? 异常就是有异于常态，和正常情况不一样，有错误出错。在java中，阻止当前...
Map的四种遍历
//Map的四种遍历方法 //Map不能直接遍历 ，只能通过遍历Key与Value间接遍历 public static...
throw和throws的区别以及try,catch,finally在有return的情况下执行的顺序
一，抛出异常有三种形式，一是throw,一个throws，还有一种系统自动抛异常。下面它们之间的...
Jdk14 都要出了，Jdk9 的新特性还不了解一下？
中最大的亮点是 Java 平台模块化 的引入，以及模块化 JDK。但是 还有很多其他新功能，这篇...
还看不懂同事代码？快来补一波 Java 7 语法特性
Jdk 频繁更新，新特性了解吗？每次更新都注重提高生产效率，提高 JVM 性能，推行模块化等，...
Java 12 新特性介绍，快来补一补
Java 12 早在 2019 年 3 月 19 日发布，这些新特性你知道吗
PHPJavaJava SEPythonC#C&C++RubyVBasp.NetGoPerlnettyDjangoDelphiJsp.NET CoreSpringFlaskSpringbootSpringMVCLuaLaravelMybatisAspGroovyThinkPHPYiiswoole
文件时间pythonm相等性PHP Warning时间问题问题解决pcntl_signal采样点wav模块动态文本调用频率限制对外暴露多个访问请求更新数据表模型结构type()方法比较速度手写体sobel算子保存模型Image类nn.Conv2dpytorch1.0kaggleDCGAN交并比range()用法打印模型反卷积卷积