java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: Exception during RTSMgrBean.findAll : com.logistics.javalib.persistence.layer.PersistLayerExc eption: org.hibernate.QueryException: fetch may not be used with scroll() or iterate() [select count(*) from com.logistics.so .rts.bo.RTS rts LEFT OUTER JOIN fetch rts.rtsLineItems as rli where rts.tcCompanyId in(95612190,95612192,95611892) and rts.bu sinessPartnerId in( 'Relation', 'jorela', 'dkdk', 'jorelati') and rli.regionIdInteger in ('')]

Hibernate JIRA | Jogeswara Rao | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Getting exception while executing the HQL query having Left Outer Join with fetch option in the form clause... <2006-04-06 14:22:11,304> <ERROR> <JLib - UI> - <java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: Exception during RTSMgrBean.findAll : com.logistics.javalib.persistence.layer.PersistLayerExc eption: org.hibernate.QueryException: fetch may not be used with scroll() or iterate() [select count(*) from com.logistics.so .rts.bo.RTS rts LEFT OUTER JOIN fetch rts.rtsLineItems as rli where rts.tcCompanyId in(95612190,95612192,95611892) and rts.bu sinessPartnerId in( 'Relation', 'jorela', 'dkdk', 'jorelati') and rli.regionIdInteger in ('')] at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:186) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:247) at com.logistics.so.rts.ejb.RTSMgrBean_t9iaop_EOImpl_814_WLStub.findAll(Unknown Source) at webroot.jsp_servlet._ofr._rts._jsp.__vendorrtslist._jspService(__vendorrtslist.java:2183) at weblogic.servlet.jsp.JspBase.service(JspBase.java:33) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:463) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:328) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) at com.oroad.stxx.plugin.StxxRequestProcessor.doForward(StxxRequestProcessor.java:115) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) at com.oroad.stxx.plugin.StxxRequestProcessor.processForwardConfig(StxxRequestProcessor.java:149) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at com.logistics.javalib.controller.servlet.SessionIdleTimeoutServlet.processRequest(SessionIdleTimeoutServlet.java:1 07) at com.logistics.javalib.controller.servlet.SessionIdleTimeoutServlet.doGet(SessionIdleTimeoutServlet.java:95) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6722) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) Caused by: javax.ejb.EJBException: Exception during RTSMgrBean.findAll : com.logistics.javalib.persistence.layer.PersistLayer Exception: org.hibernate.QueryException: fetch may not be used with scroll() or iterate() [select count(*) from com.logistics .so.rts.bo.RTS rts LEFT OUTER JOIN fetch rts.rtsLineItems as rli where rts.tcCompanyId in(95612190,95612192,95611892) and rts .businessPartnerId in( 'Relation', 'jorela', 'dkdk', 'jorelati') and rli.regionIdInteger in ('')] at com.logistics.so.rts.ejb.RTSMgrBean.findAll(RTSMgrBean.java:182) at com.logistics.so.rts.ejb.RTSMgrBean_t9iaop_EOImpl.findAll(RTSMgrBean_t9iaop_EOImpl.java:620) at com.logistics.so.rts.ejb.RTSMgrBean_t9iaop_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166) ... 31 more

    Hibernate JIRA | 1 decade ago | Jogeswara Rao
    java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: Exception during RTSMgrBean.findAll : com.logistics.javalib.persistence.layer.PersistLayerExc eption: org.hibernate.QueryException: fetch may not be used with scroll() or iterate() [select count(*) from com.logistics.so .rts.bo.RTS rts LEFT OUTER JOIN fetch rts.rtsLineItems as rli where rts.tcCompanyId in(95612190,95612192,95611892) and rts.bu sinessPartnerId in( 'Relation', 'jorela', 'dkdk', 'jorelati') and rli.regionIdInteger in ('')]

    Root Cause Analysis

    1. javax.ejb.EJBException

      Exception during RTSMgrBean.findAll : com.logistics.javalib.persistence.layer.PersistLayer Exception: org.hibernate.QueryException: fetch may not be used with scroll() or iterate() [select count(*) from com.logistics .so.rts.bo.RTS rts LEFT OUTER JOIN fetch rts.rtsLineItems as rli where rts.tcCompanyId in(95612190,95612192,95611892) and rts .businessPartnerId in( 'Relation', 'jorela', 'dkdk', 'jorelati') and rli.regionIdInteger in ('')]

      at com.logistics.so.rts.ejb.RTSMgrBean.findAll()
    2. com.logistics.so
      RTSMgrBean_t9iaop_EOImpl_WLSkel.invoke
      1. com.logistics.so.rts.ejb.RTSMgrBean.findAll(RTSMgrBean.java:182)
      2. com.logistics.so.rts.ejb.RTSMgrBean_t9iaop_EOImpl.findAll(RTSMgrBean_t9iaop_EOImpl.java:620)
      3. com.logistics.so.rts.ejb.RTSMgrBean_t9iaop_EOImpl_WLSkel.invoke(Unknown Source)
      3 frames
    3. weblogic.rmi.internal
      ServerRequest.sendReceive
      1. weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166)
      1 frame
    4. weblogic.rmi.cluster
      ReplicaAwareRemoteRef.invoke
      1. weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290)
      2. weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:247)
      2 frames
    5. com.logistics.so
      RTSMgrBean_t9iaop_EOImpl_814_WLStub.findAll
      1. com.logistics.so.rts.ejb.RTSMgrBean_t9iaop_EOImpl_814_WLStub.findAll(Unknown Source)
      1 frame
    6. webroot.jsp_servlet._ofr
      __vendorrtslist._jspService
      1. webroot.jsp_servlet._ofr._rts._jsp.__vendorrtslist._jspService(__vendorrtslist.java:2183)
      1 frame
    7. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
      1 frame
    8. Atmosphere weblogic
      RequestDispatcherImpl.forward
      1. weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
      2. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
      3. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:463)
      4. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
      5. weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:328)
      5 frames
    9. struts
      RequestProcessor.doForward
      1. org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
      1 frame
    10. com.oroad.stxx
      StxxRequestProcessor.doForward
      1. com.oroad.stxx.plugin.StxxRequestProcessor.doForward(StxxRequestProcessor.java:115)
      1 frame
    11. struts
      RequestProcessor.processForwardConfig
      1. org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
      1 frame
    12. com.oroad.stxx
      StxxRequestProcessor.processForwardConfig
      1. com.oroad.stxx.plugin.StxxRequestProcessor.processForwardConfig(StxxRequestProcessor.java:149)
      1 frame
    13. struts
      ActionServlet.doGet
      1. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
      2. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      3. org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
      3 frames
    14. com.logistics.javalib
      SessionIdleTimeoutServlet.doGet
      1. com.logistics.javalib.controller.servlet.SessionIdleTimeoutServlet.processRequest(SessionIdleTimeoutServlet.java:107)
      2. com.logistics.javalib.controller.servlet.SessionIdleTimeoutServlet.doGet(SessionIdleTimeoutServlet.java:95)
      2 frames
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    16. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
      2. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
      3. weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
      4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6722)
      4 frames
    17. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    18. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
      1 frame
    19. Atmosphere weblogic
      ServletRequestImpl.execute
      1. weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
      2. weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
      2 frames
    20. weblogic.kernel
      ExecuteThread.run
      1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
      2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
      2 frames