Re: JDBC gripe list - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC gripe list
Date
Msg-id AANLkTi=MMJk-8R38V2RGYKuqwZCeFZfA1fzM8bwKeBGd@mail.gmail.com
Whole thread Raw
In response to Re: JDBC gripe list  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: JDBC gripe list
List pgsql-jdbc
On 28 March 2011 02:31, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> Dave Cramer  wrote:
>
>> My sense is that for basic read/write/update/delete the driver
>> works just fine. However I'd like to compile a list of everyone's
>> gripe.
>
> At the top of my list is the need to use a cursor to avoid
> materializing the entire result set in heap during execution of an
> execute method.  Pulling data off the wire should be done in
> ResultSet.next() method.

Do you mean something beyond the batching you can do by setting a
suitable fetchsize?
Or do you mean you want to lift the restrictions on when that batching
can actually be used?
Or something else?

Oliver

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: idea to have driver return immediately after a query
Next
From: Dave Cramer
Date:
Subject: Re: JDBC gripe list