Re: Result set closed! Help Urgent!

Hi,
verify calling to pb.close, pb.commit transaction method :

if you call pb.close or pb.commit transaction befor sending result of your
query to your business layer you lost
the result set.

hope that help you.


On 9/19/06, Vagula <[email protected]> wrote:
>
>
> Hi,
>
>
>
>             I'm getting the following error when trying access a
> particular screen:
>
>
>
>
> org.apache.ojb.broker.PersistenceBrokerException:
>
> org.apache.ojb.broker.PersistenceBrokerSQLException: Calling
>
> ResultSet.next() failed
>
>       at
>
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk
> nown
>
> Source)
>
>       at
>
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk
> nown
>
> Source)
>
>       at
>
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un
> known
>
> Source)
>
>       at
>
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu
> ery(Unknown
>
> Source)
>
>       at
>
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQu
> ery(Unknown
>
> Source)
>
>       at
>
> com.inetpsa.pac.service.common.IndividualSearchService.getResults(Indivi
> dualSearchService.java:132)
>
>       at
>
> com.inetpsa.pac.service.common.SearchService.doExecute(SearchService.jav
> a:210)
>
>       at
>
> com.inetpsa.fwk.service.BusinessService.execute(BusinessService.java:402
> )
>
>       at com.inetpsa.pac.util.SearchList.getResults(SearchList.java:387)
>
>       at com.inetpsa.pac.util.SearchList.loadPage(SearchList.java:474)
>
>       at com.inetpsa.pac.util.SearchList.<init>(SearchList.java:134)
>
>       at
>
> com.inetpsa.pac.ui.action.common.IndividualSearchAction.searchAffectatio
> n(IndividualSearchAction.java:413)
>
>       at
>
> com.inetpsa.pac.ui.action.common.IndividualSearchAction.doExecute(Indivi
> dualSearchAction.java:189)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKActionWrapper.doExecute(FWKActionWrappe
> r.java:118)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKActionWrapper.execute(FWKActionWrapper.
> java:99)
>
>       at
> com.inetpsa.fwk.struts.action.FWKAction.execute(FWKAction.java:90)
>
>       at
>
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
> ocessor.java:484)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKLayoutRequestProcessor.parentProcessAct
> ionPerform(FWKLayoutRequestProcessor.java:146)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKRequestProcessorWrapper.processActionPe
> rform(FWKRequestProcessorWrapper.java:603)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKLayoutRequestProcessor.processActionPer
> form(FWKLayoutRequestProcessor.java:68)
>
>       at
>
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
> 274)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKLayoutRequestProcessor.parentProcess(FW
> KLayoutRequestProcessor.java:121)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKRequestProcessorWrapper.process(FWKRequ
> estProcessorWrapper.java:795)
>
>       at
>
> com.inetpsa.fwk.struts.action.FWKLayoutRequestProcessor.process(FWKLayou
> tRequestProcessor.java:58)
>
>       at
>
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
>
>       at
>
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
>
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>
>       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
> rvletInstance.java:110)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
> fecycleServlet.java:174)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
> Servlet.java:313)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
> ecycleServlet.java:116)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
> java:292)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
> dServletReferenceState.java:42)
>
>       at
>
> com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
> tInstanceReference.java:47)
>
>       at
>
> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
> ain.java:76)
>
>       at
>
> com.inetpsa.pac.arch.util.RequestEncodingFilter.doFilter(RequestEncoding
> Filter.java:72)
>
>       at
>
> com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInst
> anceWrapper.java:132)
>
>       at
>
> com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCh
> ain.java:71)
>
>       at
>
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
> tch(WebAppRequestDispatcher.java:1078)
>
>       at
>
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
> questDispatcher.java:639)
>
>       at
>
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
> uestDispatcher.java:209)
>
>       at
>
> com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:1
> 27)
>
>       at
>
> com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
> oker.java:286)
>
>       at
>
> com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
> on(CachedInvocation.java:71)
>
>       at
>
> com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
> tRequestProcessor.java:286)
>
>       at
>
> com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.dispatch(
> WS390Router.java:405)
>
>       at
>
> com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.dispatchB
> yURI(WS390Router.java:364)
>
>       at
>
> com.ibm.ws390.wc.httpcatcher.WS390Router$WS390RouterDispatcher.service(W
> S390Router.java:318)
>
>       at
>
> com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
> .java:70)
>
>       at
>
> com.ibm.ws390.wc.http.HttpConnection.readAndHandleRequest(HttpConnection
> .java:810)
>
>       at
>
> com.ibm.ws390.wc.http.HttpConnection.handle390Request(HttpConnection.jav
> a:701)
>
>       at
>
> com.ibm.ws390.wc.httpcatcher.WS390HttpTransport.handleRequest(WS390HttpT
> ransport.java:94)
>
>       at
>
> com.ibm.ws390.wc.httpcatcher.WS390HttpTransportWrapper.httprequest(WS390
> HttpTransportWrapper.java:58)
>
>       at
>
> com.ibm.ws390.orb.ServerRegionBridge.httpinvoke(ServerRegionBridge.java:
> 704)
>
>       at
>
> com.ibm.ws390.orb.ORBEJSBridge.httpinvoke(ORBEJSBridge.java(Inlined
>
> Compiled Code))
>
>       at
>
> com.ibm.ws390.orb.parameters.HTTPInvoke.HTTPInvokeParmSetter(HTTPInvoke.
> java(Compiled
>
> Code))
>
> Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: Calling
>
> ResultSet.next() failed
>
>       at org.apache.ojb.broker.accesslayer.RsIterator.hasNext(Unknown
>
> Source)
>
>       at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown
> Source)
>
>       at org.apache.ojb.broker.accesslayer.PagingIterator.next(Unknown
>
> Source)
>
>       at
>
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unk
> nown
>
> Source)
>
>       ... 57 more
>
> Caused by: com.ibm.db2.jcc.a.SqlException: Invalid operation: result set
> closed
>
>       at com.ibm.db2.jcc.a.ue.mb(ue.java(Inlined Compiled Code))
>
>       at com.ibm.db2.jcc.a.ue.c(ue.java(Compiled Code))
>
>       at com.ibm.db2.jcc.a.ue.next(ue.java(Compiled Code))
>
>       at
>
> com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJdbcResultSet.java(Comp
> iled
>
> Code))
>
>       ... 61 more
>
>
>
>
>
>
>
>             Information's:
>
> 1.       We are Using OJB 1.0
>
> 2.       We are setting the isolation level as READ_COMMITTED through
> web.xml & ibm-web-ext.xmi.
>
> 3.       We are using WAS server
>
> 4.       The database used is DB2
>
>
>
> Please help.
>
>
>
>
>
> Regards,
>
> Vagula
>
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>