org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8

最新推荐文章于 2021-06-26 13:43:57 发布
最新推荐文章于 2021-06-26 13:43:57 发布
阅读量1.3k 收藏
点赞数
文章标签： hibernate java eclipse
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40809303/article/details/83106802
版权 
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [select * From com.jhdz.biz.entity.HouseRentalXxEntity where 1=1 ]
	at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:91)
	at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:109)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:304)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
	at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
	at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836)
	at com.jhdz.biz.dao.RentalMessageDao.getRentalMessage(RentalMessageDao.java:43)
	at com.jhdz.biz.service.impl.RentalMessageServiceImpl.getRentalMessage(RentalMessageServiceImpl.java:36)
	at com.jhdz.biz.service.impl.RentalMessageServiceImpl$$FastClassBySpringCGLIB$$c2593f3f.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at com.jhdz.biz.service.impl.RentalMessageServiceImpl$$EnhancerBySpringCGLIB$$9f25aec1.getRentalMessage(<generated>)
	at com.jhdz.biz.controller.RentalMessageController.getRentalMessage(RentalMessageController.java:25)
	at com.jhdz.biz.controller.RentalMessageController$$FastClassBySpringCGLIB$$710c9475.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at com.jhdz.common.interceptor.ControllerLogInterceptor.invoke(ControllerLogInterceptor.java:83)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at com.jhdz.biz.controller.RentalMessageController$$EnhancerBySpringCGLIB$$b077d30b.getRentalMessage(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	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.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 com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.jhdz.common.filter.SessionInjectFilter.doFilter(SessionInjectFilter.java:53)
	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:121)
	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.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	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:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)

Hibernate报错: 这个是因为在你的hql语句当中有一个*号.hibernate识别不了.如果你是在用聚合函数count的时候,将*号改成1就行了.count(1);普通查询全部不需要写前面的Select *.

 

qq981894692
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
weblogic10.3 org.hibernate.hql.ast.HqlToken报错问题
04-09
在本问题中，我们遇到了一个特定的错误，即“weblogic10.3 org.hibernate.hql.ast.HqlToken报错”，这涉及到Hibernate ORM框架和其在WebLogic上的运行。让我们深入探讨这个问题，以及可能的解决方案。 首先，`org....
weblogic12 下 org.hibernate.hql.ast.HqlToken
04-20
weblogic12 下最新 org.hibernate.hql.ast.HqlToken解决办法
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELE
weixin_45311284的博客
06-18 2462
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [SELECT * FROM person p WHERE p.id = (SELECT max(p2.id) FROM person p2)] 异常原因: SQL语句出现了错误, 错误写法: @Query(value="SELECT p FROM person p WHERE p.id = (SELECT max(p2
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [sele
信徒博客
01-10 9304
错误信息如下： 背景：Spring+HIbernate+Struts2整合对数据库的增删改查 错误代码如下： public String select_info() { // 1.根据传递过的id查询整条数据 Session session = getSession(); String sql = "select * from Goods where goodnum=?";...
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.
unexpected token: * near line 1, column 8 [select * from t_user where 1=1]
热门推荐
Nio96的专栏
01-26 1万+
unexpected token: * near line 1, column 8 [select * from t_user where 1=1]      和 users is not mapped  这个错误可能是因为以下原因导致： 1.在hibernate里面写sql执行时候要用了session.createQuery(sql); 需要用session.createSQL
hibernate hql语句 投影查询的三种方式.docx
06-19
在Hibernate框架中，HQL（Hibernate Query Language）是用于操作对象关系映射的查询语言，类似于SQL，但它是面向对象的。本篇文章将详细介绍在Hibernate中进行投影查询的三种主要方式：直接查询、查询返回对象以及...
Hibernate_HQL.rar_hibernate HQL_hibernate hql src
09-19
对hibernate的hql进行了详尽的讲解
hibernate-原理共2页.pdf.zip
10-29
Hibernate通过XML映射文件（如`*.hbm.xml`）或注解将Java类与数据库表关联。映射文件定义了类的属性与数据库字段的对应关系，包括主键、非主键、关系映射等。 3. **Session与Transaction** Session是Hibernate的...
org.hibernate.hql.internal.ast.QuerySyntaxException 异常之一解决方案
qq_40881285的博客
02-23 1769
源码 public PageImpl getList(Pageable pageable, PageImpl pageImpl, UseSealApply useSealApply) { StringBuilder querySql = new StringBuilder(); List<Object> para = new ArrayList<>(); querySql.append(" from UseSealApply");
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: limit near line 1, column240
weixin_44131922的博客
06-26 1287
原因： sessionFactory.getCurrentSession().createQuery(sql);开启的是hibernate的面向对象语句所以不可以 解决反方式： 修改为 sessionFactory.getCurrentSession().createSQLQuery(sql)
hibernate 报错 line 1:1: unexpected token: .124
qq_35839428的博客
11-21 8405
今天头疼了一早上,   hibernate 报错 line 1:1: unexpected token: .124 楼主因为根据业务需求 ,需要根据IP 查询,  写了一个HQL 查询语句, 结果 报上面的错误, 经过反复测试后,  结果发现token: 后面的数字每次都不一样, 然后正好又跟我填写的IP 末尾一样,  比如我填写一个 192.161.1.124  就会
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: * near line 1, column
思考的蜗牛
04-12 505
在执行这个方法时： public List&lt;Sendnews&gt; selectSNbyUid(int id) { String sql = "select * from Sendnews s where s.isdel not in (1,2) and s.newid in (select n.newid from News n where n.uid=? and n.ispubli...
orm.hibernate3.HibernateQueryException: unexpected token: :
chuncui2576的博客
06-11 518
今天写HQL 语句的时候， 因为 必须采用拼接HQL的方式来写。 比如在 拼接 时间字符串的时候 比如 “ 2019-02-11 12:20:12” 的时候， 项目就报错了。 orm.hibernate3.HibernateQueryException: unexpected token...
关于异常：Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: Company near
run的博客
05-23 1494
查看一下你的HQL语句有没有写错了，该加空格的是不是没有加了。
SSH框架-unexpected token: * near line 1, column 8 [select * from tb_chaper where course_id = 2];报错解决方法
dearbaba_8520的博客
04-20 280
SSH框架-unexpected token: * near line 1, column 8 [select * from tb_chaper where course_id = 2];报错解决方法
org.hibernate.hql.internal.ast.QuerySyntaxException
weixin_30797199的博客
05-30 416
1.上面说的是数据表没有经过映射导致更新数据表的时候出错 2.主要原因我觉得有以下几个： ①hibernate已经把数据表映射成为一个对象 在写查询语句（hql语句）的时候如果没有将hql语句中的数据表的名字写成和类的名字一直将会报错，所以会提示数据表是没有经过映射的。而我上面的错误就是这个，经过改正之后就正确了。 修改为： 如果正确，则在控制台中会显示发送的sql语句 ...
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: LIMIT near line 1
最新发布
07-12
这个异常通常是由于在 Hibernate HQL 查询中使用了不支持的语法引起的。根据错误信息，它指出在查询的第一行附近出现了一个不期望的 "LIMIT" 标记。Hibernate 的 HQL 查询语法不支持 "LIMIT" 关键字。 如果你想使用...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值