Re: Problems with ResultSet

Its the stmnt.close() that is the problem. This will close the
ResultSet as well. You will need to close this statement at some point
but you must use the ResultSet first. Come possiblility is to return
the statement and not the result set. You can then call getResultSet()
on the statement and close the statement when you are finished.

You should also make sure that you tidy up the connection.

Cheers
Matthew.

Aydın Toprak wrote:

> Hiii,
>
>
> I have just stuck with a little point of my code which generates "This
> ResultSet is closed." exception ....
>
> here is my stack trace ...
> org.postgresql.util.PSQLException: This ResultSet is closed.
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2444)
>
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.next(AbstractJdbc2ResultSet.java:1810)
>
> org.apache.jsp.event.Proposal.frameBuyer_jsp._jspService(org.apache.jsp.event.Proposal.frameBuyer_jsp:61)
>
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) ... and
> continues...
>
>
>
> I want to return ResultSet from static method (I have never did
> before, I guess I can ..??.) ... I get resultset from my jsp page and
> want to display it ...
> so ı wrote this database access staff into another class file to
> sperate them ... anyway..
>
>
> try
> {
> stmnt = con.prepareStatement(query);
> stmnt.setInt(1, event_id);
> ps = stmnt.executeQuery();
> stmnt.close();
> connMgr.freeConnection("mypool", con);
> if(ps.next())
> out.append("This is your element :"+ps.getInt("event_id"));
> }
>
> this is the part of the code wich generated that exception...
>
> as a result of my obeservations and try... I can directly point that
> the porblem comes from this
> if(ps.next())
> out.append("This is your element :"+ps.getInt("event_id"));
>
> part of the code...
>
>
> but I dont understand why?.... the query is file, P.statement and
> connection is exist ... and also there is an integer coloumn
> "event_id" in table...
>
> is it about the static method or what..? ..
>
> Thanks..
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> _____________________________________________________________________
> This e-mail has been scanned for viruses by MCI's Internet Managed
> Scanning Services - powered by MessageLabs. For further information
> visit http://www.mci.com