result set closed

[Rajendar Goud]

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]

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]

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