Re: [GENERAL] JDBC-Question

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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Marin Dimitrov
Sent: Thursday, March 14, 2002 6:55 AM
To: pgsql-jdbc(at)postgresql(dot)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