IllegalArgumentException: No query defined for that name

最新推荐文章于 2024-01-07 04:30:00 发布
最新推荐文章于 2024-01-07 04:30:00 发布
阅读量5k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： Java 文章标签： No query defined for
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/zhaoyingjiao/article/details/52595767
本文分析了一个关于使用Hibernate框架执行SQL查询时出现的具体错误，并给出了正确的解决方案，即使用createNamedQuery代替createNativeQuery。

1. 用hibernate用sql语句查询时报错：

java.lang.IllegalArgumentException: No query defined for that name [update T_ORDER O inner join T_ORDER_PRODUCT P on O.ORDER_ID=P.ORDER_ID set O.MOD_DATE='', O.MOD_PS='', O.MOD_NAME='', O.ORDER_STATE='7' where  (O.ORDER_DATE between ? and ? ) and O.DISPATCH_DATE=?]
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.buildQueryFromName(AbstractEntityManagerImpl.java:788)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createNamedQuery(AbstractEntityManagerImpl.java:767)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:262)
	at com.sun.proxy.$Proxy34.createNamedQuery(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
	at com.sun.proxy.$Proxy70.updateOrderByPsCode(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy170.updateOrderState(Unknown Source)
	at com.*.web.controller.order.*.*(*.java:391)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
看到这篇文章才知道自己写错了，哎，太粗心了。 点击打开链接

up vote
down vote accepted

Use em.createNamedQuery(... instead of em.createNativeQuery()



深入理解java.lang.IllegalArgumentException异常
博客
08-02 5万+
IllegalArgumentException是Java的一个标准异常类，继承自RuntimeException类。当方法接收到一个非法或不合理的参数时，就会抛出该异常。本篇博客深入探讨了java.lang.IllegalArgumentException异常的相关知识。我们了解了异常的概念和分类，以及异常处理机制。然后，重点介绍了IllegalArgumentException异常的定义、继承关系和触发条件。接着，我们讨论了该异常在方法参数校验、构造方法参数校验和API调用参数校验等常见场景中的应用。
使用jpa报No query defined for that name错误
weixin_33895475的博客
01-08 597
今天使用jpa创建本地查询时出现Java.lang.IllegalArgumentException: No query defined for that name。。。。。 一个很sb的问题，调用entityManager.createNamedQuery方法第一个参数传的是配置好的sql的name。 如果直接传sql，调用createNativeQuery方法就好了...
处理问题 No query defined for that name [xxxx]
weixin_43405632的博客
08-09 192
查看项目中是否重写了Hibernate中的方法，全局搜索buildLocalSessionFactory方法，查看是被否重写，其中localSessionFactoryBean.setPackagesToScan（“扫描路径”）；路径修改为最上级解决。新增了一个依赖，依赖里面新增了表，项目启动时扫描不到依赖里面的model；
Hibernate查询出现java.lang.IllegalArgumentException异常解决方法
weixin_33753003的博客
10-16 2067
Hibernate查询出现java.lang.IllegalArgumentException。 异常信息如下:java.lang.IllegalArgumentException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAcce...
Note: further occurrences of HTTP request parsing errors will be logged at DEBUG level. java.lang.IllegalArgumentException: Invalid character found in the request target. The valid characters are defined in RFC 7230 and RFC 3986
最新发布
07-10
用户遇到了`java.lang.IllegalArgumentException: Invalid character found in the request target`异常，并希望了解如何修复。根据提供的引用信息，我们可以总结如下： ### 问题原因 1. **高版本Tomcat的严格校验*...
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dingdanService': Unsatisfied dependency expressed through field 'dingdanRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dingdanRepository' defined in com.kucun.dataDo.DingdanRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List com.kucun.dataDo.DingdanRepository.findByCriteria(java.lang.String,java.lang.String,java.lang.Integer)! at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:660) ~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE]
06-07
//gettersandsetters}//RepositorypublicinterfaceDingdanRepositoryextendsJpaRepository,Long>{@Query("SELECTdFROMDingdandWHEREd.nameLIKE%:name%ANDd.type=:typeANDd.status=:status")List<Dingdan>...
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'appService': Unsatisfied dependency expressed through field 'repositoryService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dynamicRepositoryService': Unsatisfied dependency expressed through method 'initRepositories' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dingdanChanpinZujianRepository' defined in com.kucun.dataDo.DingdanChanpinZujianRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Failed to create query for method public abstract boolean com.kucun.dataDo.DingdanChanpinZujianRepository.existsByDingdan_IdAndChanpin_zujian_Id(java.lang.Integer,java.lang.Integer)! No property chanpin found for type Dingdan_chanpin_zujian! at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:660) ~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.2.15.RELEASE.jar:5.2.15.RELEASE] at org.springframework.beans.factory.anno
06-19
No property chanpin found for type Dingdan_chanpin_zujian! ``` 这表明即使尝试使用`existsByDingdan_IdAndChanpin_zujian_Id`方法名，Spring Data JPA仍然无法正确解析实体属性。根本原因是实体类中的**下划线...
spring websocket 经验总结
PS-ER的专栏
12-12 1559
Q: Caused By: java.lang.IllegalArgumentException: No 'javax.websocket.server.ServerContainer' ServletContext attribute. Are you running in a Servlet container that supports JSR-356? A:web.xml 版本改为3.
错误提示：java.lang.IllegalArgumentException解决方法
热门推荐
飞翔射手座
03-09 22万+
我的程序出现这个错误的原因是编译环境和运行环境的jdk版本不一致，首先是spring mvc的版本是3.*的，而我本机的jdk是jdk8，查阅资料后得知他俩的兼容性不是很好，有问题，只能用jdk7及以下的版本，所以我就在myeclipse中直接导入了一个jdk1.7，但是这样依然没有解决，这是因为，这样导入后，我的运行环境和编译环境不一致，所以就要经过以下的设置： 选中项目，单击右键-》Prope
已解决java.lang.IllegalArgumentException异常的正确解决方法，亲测有效！！！
小明的Java问道之路
01-07 3万+
IllegalArgumentException是由于传递给方法的参数非法或不正确而引发的，要解决这个问题，需要在调用方法前验证输入，并在方法内部使用断言来检查参数的有效性。
java.lang.IllegalStateException: Not supported.at org.apache.catalina.connector.
Tomcat那些事儿
12-04 759
在使用Servlet3.0的异步特性的时候，经常会遇到如下异步，表示不支持异步特性。 在Tomcat中的异常是： [quote] java.lang.IllegalStateException: Not supported. at org.apache.catalina.connector.Request.startAsync(Request.java:1673) [/quote] 在...
IllegalStateException: javax.websocket.server.ServerContainer not available 其他解决办法，你搞了好久都没解决可能就是因为这个
槐序二十四的博客
10-23 1223
我****************，其他博客都教的什么？？？？ 有教导入其他Jar包的，比如这一堆~ 还有教用Jetty容器的去除内置tomcat的， 有教跳过Test打包的， 还有教在@Bean上加别的注解的， 还有去除@Bean的？？？？ 那我写他干啥？我干脆不写不就完了？？？？ 我的项目中pom.xml原本的模样， 解决办法也很简单， 就用原本的内置Tomcat！！！！用你的小手，把Jetty给我删掉 告辞~ ...
数据库查询时报IllegalArgumentException异常是什么原因？
weixin_61016066的博客
12-28 2万+
javaweb项目在使用方法时抛出IllegalArgumentException是什么原因呢？哪里出了问题呢？有类似问题的可以参考此文章，希望对各位程序员小伙伴有所帮助！！
No query specified(Mysql数据库报错)
LiZhen314的博客
08-24 7739
虽然可以正确执行，但是也出现了报错。经过一番查找和尝试发现当命令结尾不加分号的时候不报错，因此出现此错误的原因是因为执行命令: show create procedure protest.pro_test1\G;的时候,多加了一个“;可以以此类推，不管执行什么命令，\G后不用加分号，否则就会出现此类错误。我在使用语句 show create procedure protest.pro_test1\G；查询存储过程的时候出现了错误： ERROR: No query specified。
java.lang.IllegalArgumentException异常解决
静待花开
07-03 17万+
在maven项目中测试代码的时候，碰到java.lang.IllegalArgumentException异常：严重: Servlet.service() for servlet [e3-manager] in context with path [] threw exception [Request processing failed; nested exception is java.lang...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值