IllegalArgumentException: No query defined for that name

最新推荐文章于 2024-04-26 23:14:13 发布
原创 最新推荐文章于 2024-04-26 23:14:13 发布 · 5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#No query defined for

本文分析了一个关于使用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调用参数校验等常见场景中的应用。
Caused by: java.lang.IllegalStateException: javax.websocket.server.ServerContainer not available产生原因
sleepyhead1994的博客
10-18 3785
在项目部署时需要将代码打包放到服务器上，打包的时候报了如下的错误，但是在idea上却是能正常运行的。 java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelega...
使用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方法就好了...
java代码链接并操作数据库时出现问题总结
毅香雪海的博客
04-28 1103
1. No query defined for that name 可能原因：在hibernate.cfg.xml的<mapping>没有配置该实体类的路径。 2. SQLGrammarException: could not extract ResultSet. 可能原因： 1）数据库或表不存在 2）实体类与表字段对应不上...
处理问题 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-boot-starter-websocket使用问题
m0_60541110的博客
03-20 1717
项目中的websocket突然连不上了，检查后台发现报的这个错误 No 'jakarta.websocket.server.ServerContainer' ServletContext attribute. Are you running in a Servlet container that supports JSR-356 ，经过排查终于找到原因，在此记录下。
java.lang.IllegalStateException: javax.websocket.server.ServerContainer not available
yanlici1249075710的博客
05-28 8518
"C:\Program Files\Java\jdk1.8.0_251\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.3\lib\idea_rt.jar=53883:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.3\bin" -Dfile.encoding=UTF-8 -.
springboot中移除tomcat插件的方法
Mr_lambor的博客
10-05 1817
<dependency>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-web</artifactId>    <!-- 从依赖信息里移除 Tomca...
【异常】java.lang.IllegalStateException: Attribute ‘javax.websocket.server.ServerContainer‘ not found in
我是Superman丶的博客
12-26 827
【异常】java.lang.IllegalStateException: Attribute 'javax.websocket.server.ServerContainer' not found in。找到ServerContainer接口 发现有两个实现类 所以导致报错，pom引用了多个带ServerContainer的依赖。选中之后 右键 Exclude 排除。用的Maven Helper 插件。用的Maven Helper 插件。用IDEA插件 搜索这个依赖。目前考虑排除这个依赖。
亲测有效！！！已解决java.lang.IllegalArgumentException异常，已解决java.lang.IllegalArgumentException异常的正确解决方法，亲测有效！！
PythonAigc的博客
04-26 8747
java.lang.IllegalArgumentException 是 Java 中的一个运行时异常，它表示向方法传递了一个不合法或不适当的参数。这个异常通常用于表示调用者违反了API合约，即方法调用者传递了一个方法签名预期之外的值。 问题分析 当 Java 程序抛出 IllegalArgumentException 时，意味着程序中的某个方法收到了一个不符合其要求或期望的参数。这可能是由于参数的类型错误、值范围错误、格式错误或任何其他不满足方法使用条件的情况。 报错原因 IllegalArgumen
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
IllegalStateException: javax.websocket.server.ServerContainer not available 其他解决办法，你搞了好久都没解决可能就是因为这个
槐序二十四的博客
10-23 1223
我****************，其他博客都教的什么？？？？ 有教导入其他Jar包的，比如这一堆~ 还有教用Jetty容器的去除内置tomcat的， 有教跳过Test打包的， 还有教在@Bean上加别的注解的， 还有去除@Bean的？？？？ 那我写他干啥？我干脆不写不就完了？？？？ 我的项目中pom.xml原本的模样， 解决办法也很简单， 就用原本的内置Tomcat！！！！用你的小手，把Jetty给我删掉 告辞~ ...
srping boot jar包启动报错：（IDE运行没有错误）java.lang.IllegalArgumentException
starandsea的专栏
12-14 1万+
用java运行jar文件：java -jar xxx.jar，报错 java.lang.IllegalArgumentException: No auto configuration classes found in META-INF/spring.factories. If you are using a custom packaging, make sure that file is c
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值