Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

result set closed

 
Rajendar Goud
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
i am using a DB2 driver for connecting to a java application and its able to open the database connection.but its giving the following record when trying to fetch the records..

the driver i am using is com.ibm.db2.jcc.DB2Driver

com.ibm.db2.jcc.c.SQLException: Invalid operation: result set closed
at com.ibm.db2.jcc.c.ca.T(ca.java:2682)
at com.ibm.db2.jcc.c.ca.next(ca.java:221)
at com.db.ac.mccTracking.business.query.ETListTableModelFactory.setETListTableModel(ETListTableModelFactory.java:442)
at com.db.ac.mccTracking.business.model.ETListBean.updateListData(ETListBean.java:828)
at jsp._0002fjsp_0002fETListCtrl_0002ejspETListCtrl_jsp_0._jspService(_0002fjsp_0002fETListCtrl_0002ejspETListCtrl_jsp_0.java:170)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)


in some sites i read like its a problem with the type of driver itself?
is it so ? any help most appreciated.
 
Sonny Gill
Ranch Hand
Posts: 1211
IntelliJ IDE Mac
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are probabely closing the ResultSet by mistake before you call some other method on it.
Somebody may be able to help if you post the relevant code.

cheers.
 
Rajendar Goud
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sonny,
thx for the response but i dont think its the code problem.b/c i changed the driver to COM.ibm.db2.jdbc.app.DB2Driver and its working fine.i know that the error description sounds like a problem with code but its not..

Thanks and regards
Rajendar
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic