Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: 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.runEventProcessingL oop(ResultHandler.java:741)
    [2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler .java:863)
    [2/11/09 9:52:23:906 IST] 00000028 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •