Re: Problems with ResultSet
От | João Paulo Ribeiro |
---|---|
Тема | Re: Problems with ResultSet |
Дата | |
Msg-id | 436203DD.7070000@mobicomp.com обсуждение исходный текст |
Ответ на | Re: Problems with ResultSet (David Goodenough <david.goodenough@btconnect.com>) |
Ответы |
Re: Problems with ResultSet
(Aydın Toprak <aydin.toprak@intengo.com>)
|
Список | pgsql-jdbc |
David is rigth. <br /> And try to avoid returning resultset. If your method need to return something do it with your ownobjects.<br /> Do something like:<br /><br /> -> get connection<br /> -> create statement on the connection<br />-> execute statement and get resultset<br /> -> iterate resultset and create your own object with the informationneeded<br /> -> close statement<br /> -> return the object you created with the information from the resultset<br/><br /> Note: if your using a pool always release the connection to the pool. <br /><br /><br /> Regards.<br/> João Paulo Ribeiro<br /><br /><br /> David Goodenough wrote: <blockquote cite="mid200510281132.29818.david.goodenough@btconnect.com"type="cite"><pre wrap="">Closing the statement closes everythingthat came from it, i.e. the ResultSet. So you need to delay closing the statement until after you have finished with the ResultSet. David On Friday 28 October 2005 11:18, Aydın Toprak wrote: </pre><blockquote type="cite"><pre wrap="">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(AbstractJdbc2Result Set.java:2444) org.postgresql.jdbc2.AbstractJdbc2ResultSet.next(AbstractJdbc2ResultSet.jav a:1810) org.apache.jsp.event.Proposal.frameBuyer_jsp._jspService(org.apache.jsp.eve nt.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 </pre></blockquote><pre wrap=""> ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to <a class="moz-txt-link-abbreviated"href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a> so that your messagecan get through to the mailing list cleanly </pre></blockquote><br /><br /><pre class="moz-signature" cols="72">-- João Paulo Ribeiro | Senior Software Engineer <a class="moz-txt-link-abbreviated" href="mailto:jp@mobicomp.com">jp@mobicomp.com</a> PHONE: + 351 253 305 250 FAX : + 351 253 305 250 <a class="moz-txt-link-abbreviated" href="http://www.mobicomp.com">www.mobicomp.com</a> ________________________________________________________________ About Solutions | Wireless World CONFIDENTIALITY NOTICE: This message, as well as existing attached files, is confidential and intended exclusively for theindividual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any usewhatsoever of its contents and to proceed to the destruction of the message, thereby notifying the sender. DISCLAIMER: The sender of this message can not ensure the security of its electronic transmission and consequently does notaccept liability for any fact which may interfere with the integrity of its content.</pre>
В списке pgsql-jdbc по дате отправления: