AbstractJdbc2Statement.setFetchSize()

From: Rich Cullingford <rculling(at)sysd(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: AbstractJdbc2Statement.setFetchSize()
Date: 2003-10-16 22:09:47
Message-ID: 3F8F172B.8050106@sysd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sysd(dot)com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2003-10-17 01:14:13 Re: AbstractJdbc2Statement.setFetchSize()
Previous Message Paul Thomas 2003-10-16 11:16:27 Re: Inserts disappear after some time under high load