File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes result set closed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "result set closed" Watch "result set closed" New topic
Author

result set closed

Rajendar Goud
Ranch Hand

Joined: Mar 06, 2002
Posts: 220
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

Joined: Feb 02, 2002
Posts: 1211

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

Joined: Mar 06, 2002
Posts: 220
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: result set closed
 
jQuery in Action, 3rd edition