org.hibernate.hql.ast.QuerySyntaxException解决方案

最新推荐文章于 2023-04-19 11:39:07 发布
最新推荐文章于 2023-04-19 11:39:07 发布
阅读量2.4k 收藏
点赞数
分类专栏： 异常发现与解决
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/vigor512/article/details/12339329
版权

今天在看项目的时候，突然又遇到一个错误，仔细看过之后，发现是关于HQL查询的。其实 HQL跟SQL的原理是一样的，只不过HQL更面向对象了，他是hibernate 查询语言，所以查询的时候不应该像SQL一样出现的是表名，而是相对的域模型

代码异常如下：

java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: vcr_question is not mapped [from vcr_question]
 at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:601)
 at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:96)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
 at $Proxy18.createQuery(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
 at $Proxy18.createQuery(Unknown Source)
 at com.vcr.service.impl.QuestionServiceImpl.list(QuestionServiceImpl.java:43)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 at $Proxy40.list(Unknown Source)
 at com.vcr.admin.action.QuestionAction.load(QuestionAction.java:67)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
 at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
 at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
 at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
 at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
 at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
 at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
 at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
 at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
 at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
 at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
 at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at com.rts.AdminSessionFilter.doFilter(AdminSessionFilter.java:53)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 at java.lang.Thread.run(Thread.java:619)

 

我这里给出一个例子，可能大家看的更明白

有一个表question 对应域模型是Question

String sql = "select name from question";

Query q = session.createQuery(sql);

相信大家都可以看的明白，根据你自己项目需求进行对照，错误是不是排除了呢

vigor512
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
weblogic12 下 org.hibernate.hql.ast.HqlToken
04-20
### WebLogic 12下org.hibernate.hql.ast.HqlToken冲突解决方案 在使用WebLogic 12部署应用程序时，可能会遇到与`org.hibernate.hql.ast.HqlToken`相关的异常问题。这种异常通常与Hibernate版本之间的不兼容性有关...
SSH项目，hibernate的查询操作出错org.hibernate.hql.ast.QuerySyntaxException
默默不代表沉默
02-27 2484
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [select *from Employee]org.hibernate.hql.ast.QuerySyntaxException: employee is not mapped [from employee]一.如果在调用HQ...
org.hibernate.hql.ast.QuerySyntaxException问题
HelloProcedure的博客
12-30 762
这个问题可能出现在SSH项目的select或者update的时候。问题原因如下： 在做select的时候， 1.我们在写select的时候，经常会这么写String hql=“select *from XXX ”这是一个sql语句，而hibernate框架用的是HQL语句去操作，而我们在创建的hql其实是一个sql语句，这时可能就会出现这个问题，解决办法就是把sql语句改为标准的hql语句，把...
org.hibernate.hql.ast.QuerySyntaxException
weixin_33832340的博客
11-19 141
org.hibernate.hql.ast.QuerySyntaxException:eg：org.hibernate.hql.ast.QuerySyntaxException: Admin is not mapped [select count(a)from Admin a where a.adminname=? and a.adminpwd=?]问题原因1.f...
报错org.hibernate.hql.internal.ast.QuerySyntaxException: XX is not mapped或者Unknown entity
花式芜湖的的博客
04-19 952
报错org.hibernate.hql.internal.ast.QuerySyntaxException: XX is not mapped或者Unknown entity
org.hibernate.hql.ast.QuerySyntaxException: is not mapped解决办法
热门推荐
云想衣裳花想容
03-04 2万+
is not mapped这个异常的抛出主要有几个方面： 1、首先要检查的就是不是表名，这个应该大家都知道，hql语句对大小写很严格，因此请注意大小写；你的hql语句中的from是实体类而 2、你的hibernate配置文件中没有加入相应的映射文件； 3、如果上面两方面检查了都没问题，但是还有错，那就是hql语句有错了，好好检查一下，仔细点，不行就重新写一遍，放到数据
weblogic10.3 org.hibernate.hql.ast.HqlToken报错问题
04-09
总之，解决“weblogic10.3 org.hibernate.hql.ast.HqlToken报错”问题需要对Hibernate和WebLogic有深入的理解，以及对HQL语法的熟练掌握。通过逐步排查和测试，通常能找到问题的根源并成功解决。同时，保持软件更新...
Hibernate-HQL.rar_HQL_hibernate hql
09-23
本篇文档将深入探讨Hibernate中的HQL（Hibernate Query Language），一种面向对象的查询语言，它提供了与SQL类似的语法，但更贴近于面向对象的思维模式，使得开发者可以更加便捷地进行数据查询。 一、HQL简介 HQL是...
Hibernate_HQL.rar_hibernate HQL_hibernate hql src
09-19
对hibernate的hql进行了详尽的讲解
hibernate-原理共2页.pdf.zip
10-29
Hibernate作为Java中最流行的ORM框架，提供了便捷的数据持久化解决方案。 1. **配置与初始化** Hibernate的使用首先需要进行配置，包括数据库连接信息、实体类路径等。这些信息通常在`hibernate.cfg.xml`配置文件...
org.hibernate.hql.internal.ast.QuerySyntaxException 查询操作时报错-解决
心有谦谦结
09-22 1万+
一、报错：org.hibernate.hql.internal.ast.QuerySyntaxException: XXXis not mapped [FROM XXX WHERE owner = ?1] 具体报错： Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: student is not mapped [FROM student WHERE owner = ?1] Caused by: java.lang.Ille.
Hibernate_org.hibernate.hql.ast.QuerySyntaxException: Path expected for join
ALL TECHNOLOGIES ARE CLOUDS
07-07 828
异常: org.hibernate.hql.ast.QuerySyntaxException: Path expected for join   HQL是面向对象的，所以join的条件是反映在对象的关系中的，所以，你在用join的时候，无论是left join还是right join，都是FROM DomainA a LEFT JOIN a.b b WHERE或者FROM DomainA a...
org.hibernate.hql.ast.QuerySyntaxException:is not mapped 异常总结
编程之美
11-20 1万+
java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: t_aty_disease is not mapped [SELECT new com.upup.app.doctor.symptom.entity.Symptom(d.id) FROM t_aty_disease d,t_aty_symp
org.hibernate.hql.internal.ast.QuerySyntaxException: Path expected for join!
信徒博客
03-30 3468
错误信息 org.hibernate.hql.internal.ast.QuerySyntaxException: Path expected for join! [select a,b.userlogo from cn.com.bean.AnswerPost a inner join User b where a.answer_name=b.username and a.post_id=...
Hibernate异常： org.hibernate.hql.ast.QuerySyntaxException: User is not mapped [from User]
Langdon1996的博客
04-17 795
Hibernate异常：org.hibernate.hql.ast.QuerySyntaxException: User is not mapped [from User]1、出现该错误的情况分析1，配置文件没有加载到hibernate的实体列表里面2，映射文件的字段与数据库字段不一致，或者名称不一致导致hql 是 有专门的语法的，不完全同于sql。切记HQL是大小写敏感的，这点不同于SQL。 …
Hql连接查询的两个错误（Path expected for join!和unexpected token on）
微瞰技术的博客
08-31 1640
1. Path expected for join!Path expected for join! [SELECT count() FROM cn.com.jsoft.entities.TDSysnphoto p left join TDSysnotice s where p.snid = s.id]; nested exception is org.hibernate.hql.ast.Query
org.hibernate.hql.ast.QuerySyntaxException is not mapped
最新发布
03-12
org.hibernate.hql.ast.QuerySyntaxException是Hibernate框架中的一个异常类，表示HQL查询语法错误或实体类未映射的异常。 当在Hibernate中执行HQL查询时，如果查询语法错误或者查询的实体类未正确映射到数据库表，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值