from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId=4028822d231810450123182d4c190003
2009-08-14 21:41:31,968 ERROR [org.hibernate.hql.PARSER] - line 1:139: unexpected token: 231810450123182d
2009-08-14 21:41:32,000 ERROR [com.sinovatech.common.web.action.BaseAction] - org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 231810450123182d near line 1, column 139 [from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId=4028822d231810450123182d4c190003]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 231810450123182d near line 1, column 139 [from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId=4028822d231810450123182d4c190003]
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 231810450123182d near line 1, column 139 [from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId=4028822d231810450123182d4c190003]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 231810450123182d near line 1, column 139 [from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId=4028822d231810450123182d4c190003]
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 231810450123182d near line 1, column 139 [from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId=4028822d231810450123182d4c190003]
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 org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:842)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:832)
at com.sinovatech.product.me.product.dao.MeProdPropDAO.listByTMeProductDTO(MeProdPropDAO.java:93)
at com.sinovatech.product.me.product.bpo.MeProdPropBPO.listByProductId(MeProdPropBPO.java:225)
at com.sinovatech.product.me.product.bpo.MeProdPropBPO$$FastClassByCGLIB$$1e2b9335.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.sinovatech.product.me.product.bpo.MeProdPropBPO$$EnhancerByCGLIB$$529ba943.listByProductId(<generated>)
at com.sinovatech.product.me.product.facade.MeProdPropFacade.listByProductId(MeProdPropFacade.java:208)
at com.sinovatech.product.me.product.action.MeProdPropAction.listByProduct(MeProdPropAction.java:377)
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.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
at org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:166)
at com.sinovatech.common.web.action.BaseAction.execute(BaseAction.java:91)
at com.sinovatech.common.web.action.BaseAdmAction.execute(BaseAdmAction.java:83)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.sinovatech.common.web.filter.EncodeFilter.doFilter(EncodeFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)

解决方案 »

  1.   

    4028822d231810450123182d4c190003
    给这个常量加上引号试试
      

  2.   

    QuerySyntaxException,是不是查询语句的语法发生了异常,仔细检查一下
      

  3.   

    from com.sinovatech.product.me.product.dto.TMeProdPropDTO Z left join fetch Z.tbTMeProductDTO A where Z.tbTMeProductDTO.productId='4028822d231810450123182d4c190003' 
      

  4.   

    错误中有提示,是你的hql语句有问题,即sql语句有问题,是你用的左链接语句没有写对