Re: Impact of open ResultSets and PreparedStatements ? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Impact of open ResultSets and PreparedStatements ?
Date
Msg-id Pine.BSO.4.56.0504290457210.11511@leary.csoft.net
Whole thread Raw
In response to Re: Impact of open ResultSets and PreparedStatements ?  (Antony Paul <antonypaul24@gmail.com>)
List pgsql-jdbc

On Fri, 29 Apr 2005, Antony Paul wrote:

> I am using PostgreSQL 7.3 (server and JDBC driver) and no stored
> procedures are used but uses the built in functions. I know that in
> this version PreparedStatements are not kept in the server. What about
> the ResultSet ?. Does all the data is transferred to application right
> after the query is executed or only a predefined no of records are
> returned while going through the rs.next() call ?.
>

In 7.3 all ResultSets fetch the entire result immediately leaving
nothing on the server.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Problems storing timestamps with calendars
Next
From: Oliver Siegmar
Date:
Subject: Re: Interval support for Postgres