implementation of Statement.executeQuery()

From: Jonathan Gold <jgold(at)panix(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: implementation of Statement.executeQuery()
Date: 2004-01-20 00:40:28
Message-ID: Pine.NEB.4.58.0401191936200.19988@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

i know there has been large discussion in the last year or two about
the fact that the code

ResultSet rs = someStatement.executeQuery( queryString )

causes an OutOfMemoryException for large result sets, as the backend
returns the entire result set at once, and so it must be stored in
memory while the result set exists. the current accepted solution
seems to be the use of a result set in combination with two prepared
statements -- one to create a cursor, the other to fetch from it.
there was some comment in these threads that it would be nice if that
could be fixed, and to have this functionality added to the jdbc
implementation for postgres.

what is the state of this? do people still want to do it? if so, is
anyone working on it yet?

jon

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-01-20 00:56:49 Re: implementation of Statement.executeQuery()
Previous Message Kris Jurka 2004-01-19 17:41:49 Re: clarification needed in postgresql... + transactions...