AbstractJdbc2Statement.setFetchSize() - Mailing list pgsql-jdbc

From Rich Cullingford
Subject AbstractJdbc2Statement.setFetchSize()
Date
Msg-id 3F8F172B.8050106@sysd.com
Whole thread Raw
Responses Re: AbstractJdbc2Statement.setFetchSize()
List pgsql-jdbc
All,
I had hoped to use this method, which is implemented in PG 7.4, to limit
the number of rows retrieved (for display purposes) out of some massive
datasets we have. I know the JDBC spec says that this is just a hint,
but calling the method on a Statement doesn't seem to have any effect on
the SELECT. It still seesm to try to load the whole dataset.

Is there any way to avoid cursored FETCH approaches to this problem?
                    Thanks,
                    Rich Cullingford
                    rculling@sysd.com


pgsql-jdbc by date:

Previous
From: aehansen@paycheckadv.com
Date:
Subject: ...
Next
From: Oliver Jowett
Date:
Subject: Re: AbstractJdbc2Statement.setFetchSize()