aspose file tools*
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Similar Threads
Urgent!!!! What is General Error ?
Help with EJB deployment
javax.servlet.ServletException: Cannot create bean of class...
Help with EJB deployment
jsp examples