Thread: Re: [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

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