Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Exception due to while(resultset.next())

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-10-09, 23:35
deshmukh0581 deshmukh0581 is offline
Registered User
  
Join Date: Feb 2009
Posts: 2
Exception due to while(resultset.next())
I am trying to pull data from a DB2 database
n i m getting following exception.

[2/11/09 9:52:23:896 IST] 00000028 SystemErr R com.ibm.db2.jcc.a.SqlException: Invalid operation: result set closed
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at com.ibm.db2.jcc.a.lf.lb(lf.java:3501)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at com.ibm.db2.jcc.a.lf.c(lf.java:297)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at com.ibm.db2.jcc.a.lf.next(lf.java:283)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJ dbcResultSet.java:2468)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at pmkt.web_order_form.reports.ProgramReport.printPar tTables(ProgramReport.java)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at pmkt.web_order_form.reports.CategoryReport.printPr ogramDetails(CategoryReport.java)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at pmkt.web_order_form.reports.ProgramReport.generate (ProgramReport.java:164)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at pmkt.web_order_form.OrderFormServlet.doPost(OrderF ormServlet.java:273)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at pmkt.web_order_form.OrderFormServlet.doGet(OrderFo rmServlet.java:101)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet .java:743)
[2/11/09 9:52:23:896 IST] 00000028 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:972)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:478)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.h andleRequest(ServletWrapper.java:463)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.extension.InvokerExtension Processor.handleRequest(InvokerExtensionProcessor. java:263)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleReques t(WebApp.java:3129)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequ est(WebGroup.java:238)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:811)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleReque st(WebContainer.java:1433)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:93)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:465)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:394)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.ready(HttpInboundLink.java:274)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialRe adCallback.sendToDiscriminators(NewConnectionIniti alReadCallback.java:214)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialRe adCallback.complete(NewConnectionInitialReadCallba ck.java:113)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListe ner.futureCompleted(AioReadCompletionListener.java :152)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallbac k(AbstractAsyncFuture.java:213)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.fireCompletio nActions(AbstractAsyncFuture.java:195)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture .java:136)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHand ler.java:194)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.ResultHandler****nEventProcessingL oop(ResultHandler.java:741)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.ResultHandler$2****n(ResultHandler .java:863)
[2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.util.ThreadPool$Worker****n(ThreadPool.j ava:1510)

and this exception is due to following statement
"while(resultset.next())"


Any clue what might be causing this?
thanx in Advance
Reply With Quote
  #2 (permalink)  
Old 02-11-09, 09:20
stolze stolze is offline
Registered User
  
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Yes, I do. You closed the result set as the message tells you. Once a result set is closed, you cannot read from it anymore.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.