Problems with ResultSet

From: Aydın Toprak <aydin(dot)toprak(at)intengo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problems with ResultSet
Date: 2005-10-28 10:18:09
Message-ID: 4361FAE1.4010806@intengo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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..

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Goodenough 2005-10-28 10:32:28 Re: Problems with ResultSet
Previous Message Matt Magoffin 2005-10-28 00:36:42 Re: INTERVAL parameter in PreparedStatement worked in