File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "result set closed" Watch "result set closed" New topic

result set closed

Rajendar Goud
Ranch Hand

Joined: Mar 06, 2002
Posts: 220
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 Invalid operation: result set closed
at jsp._0002fjsp_0002fETListCtrl_0002ejspETListCtrl_jsp_0._jspService(
at org.apache.jasper.runtime.HttpJspBase.service(
at javax.servlet.http.HttpServlet.service(
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(
at javax.servlet.http.HttpServlet.service(
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(
at org.apache.jasper.servlet.JspServlet.serviceJspFile(
at org.apache.jasper.servlet.JspServlet.service(
at javax.servlet.http.HttpServlet.service(
at org.apache.tomcat.core.ServletWrapper.doService(
at org.apache.tomcat.core.Handler.service(
at org.apache.tomcat.core.ServletWrapper.service(
at org.apache.tomcat.core.ContextManager.internalService(
at org.apache.tomcat.core.ContextManager.service(
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(
at org.apache.tomcat.service.TcpWorkerThread.runIt(
at org.apache.tomcat.util.ThreadPool$

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.

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 and its working fine.i know that the error description sounds like a problem with code but its not..

Thanks and regards
I agree. Here's the link:
subject: result set closed
It's not a secret anymore!