Re: [GENERAL] JDBC-Question - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: [GENERAL] JDBC-Question
Date
Msg-id 00bc01c1cb57$d4df45c0$0b01a8c0@inspiron
Whole thread Raw
In response to Re: [GENERAL] JDBC-Question  ("Marin Dimitrov" <marin.dimitrov@sirma.bg>)
List pgsql-jdbc
Actually, at the moment the driver gets all the result set at once, so
no setFetchSize() isn't implemented.

However you can get a cursor back and scroll through the result set
yourself

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Marin Dimitrov
Sent: Thursday, March 14, 2002 6:55 AM
To: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] [GENERAL] JDBC-Question


>
> Do I have all the data (1000 rows) in memory or dose the driver fetch
> the data as needed (while iterating over the rset instance) from my
> postgresql backend.
>

since I would expect that the driver retrieves the result sets in chunks
I'd like to know if this behaviour can be controlled - i.e. is
setFetchSize() implemented?

thanx,

    Marin



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



pgsql-jdbc by date:

Previous
From: "Marin Dimitrov"
Date:
Subject: Re: [GENERAL] JDBC-Question
Next
From: Kovács Péter
Date:
Subject: Re: measure of JDBC performances