java hql left join_hibernate left join报错(急!在线等)

最新推荐文章于 2021-04-06 20:42:07 发布

爱吃火锅的上官燕

最新推荐文章于 2021-04-06 20:42:07 发布

阅读量315

点赞数

文章标签： java hql left join

本文链接：https://blog.csdn.net/weixin_32809369/article/details/114763167

版权

我的在mysql里正确执行的语句,转到hibernate里就报错,反正用了left join 就报错:

select

d.diary_id,

d.user_id,

d.content,

u.nick_name,

count(r.re_id)

from user_info u,diary d

left join

diary_comment r

r.diary_id = d.diary_id

where

d.user_id = u.user_id

and

d.user_id="DL00000001"

and

d.delete_flag='0'

group by

d.diary_id

order by

d.issue_time desc

以下报错:

Dispatch[/user/diary] to method 'mylist' returned an exception

java.lang.reflect.InvocationTargetException

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:585)

at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:266)

at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:167)

at com.sinoconcept.diglover.struts.diary.action.DiaryAction.execute(DiaryAction.java:50)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:446)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

Caused by: java.lang.NoSuchMethodError: org.hibernate.hql.antlr.HqlBaseParser.recover(Lantlr/RecognitionException;Lantlr/collections/impl/BitSet

at org.hibernate.hql.antlr.HqlBaseParser.fromJoin(HqlBaseParser.java:1802)

at org.hibernate.hql.antlr.HqlBaseParser.fromClause(HqlBaseParser.java:1420)

at org.hibernate.hql.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1130)

at org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:702)

at org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:296)

at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:159)

at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:238)

at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155)

at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:75)

at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:54)

at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)

at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134)

at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113)

at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1602)

at com.sinoconcept.diglover.dao.impl.BaseDAOHibernateImpl.getCounts(BaseDAOHibernateImpl.java:211)

at com.sinoconcept.diglover.dao.impl.BaseDAOHibernateImpl$$FastClassByCGLIB$$233c381d.invoke(

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:674)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:615)

at com.sinoconcept.diglover.dao.impl.DiaryDAOHibernateImpl$$EnhancerByCGLIB$$20a8aa8.getCounts(

at com.sinoconcept.diglover.service.impl.DiaryServiceImpl.findDiaryVOByUserId(DiaryServiceImpl.java:194)

at com.sinoconcept.diglover.service.impl.DiaryServiceImpl$$FastClassByCGLIB$$a6e8f2a1.invoke(

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:674)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:615)

at com.sinoconcept.diglover.service.impl.DiaryServiceImpl$$EnhancerByCGLIB$$85aa3372.findDiaryVOByUserId(

at com.sinoconcept.diglover.struts.diary.action.DiaryAction.mylist(DiaryAction.java:155)

... 31 more

14:16:22,312 WARN [struts.util.PropertyMessageResources] Resource org/apache/struts/action/ActionResources_zh_CN.properties Not Found.

14:16:22,312 WARN [struts.util.PropertyMessageResources] Resource org/apache/struts/action/ActionResources_zh.properties Not Found.

14:16:22,421 WARN [struts.action.RequestProcessor] Unhandled Exception thrown: class javax.servlet.ServletException

14:16:22,421 ERROR [com].[/].[action]] Servlet.service() for servlet action threw exception

java.lang.NoSuchMethodError: org.hibernate.hql.antlr.HqlBaseParser.recover(Lantlr/RecognitionException;Lantlr/collections/impl/BitSet