Result set closed! Help Urgent!

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