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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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