You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Vagula <Va...@infosys.com> on 2006/09/19 14:02:02 UTC
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***
Re: Result set closed! Help Urgent!
Posted by ABOU LINA <am...@gmail.com>.
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 <Va...@infosys.com> 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***
>