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

最新推荐文章于 2020-08-14 10:20:45 发布

fuyan123

最新推荐文章于 2020-08-14 10:20:45 发布

阅读量839

点赞数

分类专栏： Exception 文章标签： Hibernate

本文链接：https://blog.csdn.net/fuyan123/article/details/83970357

版权

Exception 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

错误原因：HQL语言和SQL语言混合使用的结果
解决办法：两种只能选择一种来使用

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [select * from tbl_orderproduct where o_orderid in (select o_orderid from tbl_order where o_orderstate='B239' and o_inputtime >'2008-09-01' and o_inputtime<'2008-09-11' )]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
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.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1202)
at $Proxy5.createQuery(Unknown Source)
at com.yulin.cigarette.businessimpl.GenericImpl$2.doInHibernate(GenericImpl.java:72)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)\..