Re: Impact of open ResultSets and PreparedStatements ?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Antony Paul <antonypaul24(at)gmail(dot)com>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Impact of open ResultSets and PreparedStatements ?
Date: 2005-04-29 09:58:34
Message-ID: Pine.BSO.4.56.0504290457210.11511@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Siegmar 2005-04-29 10:25:08 Re: Interval support for Postgres
Previous Message Kris Jurka 2005-04-29 09:51:51 Re: Problems storing timestamps with calendars