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***