Re: not fetching all query results

Further more the spec actually says the default is 0

Gives the JDBC driver a hint as to the number of rows that should be
fetched from the database when more rows are needed for ResultSet
objects genrated by this Statement. If the value specified is zero,
then the hint is ignored. The default value is zero.


dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Tue, Jul 17, 2012 at 2:28 PM, Dave Cramer <pg@fastcrypt.com> wrote:
> Well the default is 0 which means that it is off, if you want to
> activate it then set it to something.
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On Tue, Jul 17, 2012 at 2:14 PM, Radim Kolar <hsn@filez.com> wrote:
>>
>> setFetchSize is defined there:
>>
>> https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/jdbc2/AbstractJdbc2Statement.java
>>
>> but i havent checked if this value is really used for something. But
>> probably not because its OOM here if result set is over 30k rows.
>>
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc