Re: Problems with ResultSet
От | Ken Geis |
---|---|
Тема | Re: Problems with ResultSet |
Дата | |
Msg-id | 5d7d229cd5bd8c2cb904161933c98349@speakeasy.net обсуждение исходный текст |
Ответ на | Re: Problems with ResultSet (Aydın Toprak <aydin.toprak@intengo.com>) |
Список | pgsql-jdbc |
CachedRowSet does what you want to do. There's a good explanation here: http://www.onjava.com/pub/a/onjava/2004/06/23/cachedrowset.html Ken On Oct 28, 2005, at 5:38 AM, Aydın Toprak wrote: > > Ok you are right, that works... however I really dont understand why > it fails... > I though that I get all the results in my ResultSet obeject and keep > it safe , distant from closing connections or statements... > > as for returning my objects, > I want all the result set .. so that I think,in these circumstances, > there is no need to generate my own objects and add them to the > returning vector... > > am I mising a point? > > > > > > João Paulo Ribeiro wrote: > >> David is rigth. >> And try to avoid returning resultset. If your method need to return >> something do it with your own objects. >> Do something like: >> >> -> get connection >> -> create statement on the connection >> -> execute statement and get resultset >> -> iterate resultset and create your own object with the information >> needed >> -> close statement >> -> return the object you created with the information from the >> resultset >> >> Note: if your using a pool always release the connection to the pool. >> >> >> Regards. >> João Paulo Ribeiro >> >> >> David Goodenough wrote: >> >>> Closing the statement closes everything that 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: >>> >>>> 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(AbstractJdbc >>>> 2Result >>>> Set.java:2444) >>>> >>>> org.postgresql.jdbc2.AbstractJdbc2ResultSet.next(AbstractJdbc2Result >>>> Set.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 >>>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 1: if posting/reading through Usenet, please send an appropriate >>> subscribe-nomail command to majordomo@postgresql.org so that >>> your >>> message can get through to the mailing list cleanly >>> >>> >>> >> >> >> -- >> João Paulo Ribeiro | Senior Software Engineer >> jp@mobicomp.com >> >> PHONE: + 351 253 305 250 >> FAX : + 351 253 305 250 >> www.mobicomp.com >> >> ________________________________________________________________ >> >> About Solutions | Wireless World >> >> CONFIDENTIALITY NOTICE: This message, as well as existing attached >> files, is confidential and intended exclusively for the individual(s) >> named as addressees. If you are not the intended recipient, you are >> kindly requested not to make any use whatsoever 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 not accept >> liability for any fact which may interfere with the integrity of its >> content. >> > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend
В списке pgsql-jdbc по дате отправления: