Re: not fetching all query results - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: not fetching all query results
Date
Msg-id CADK3HH+HEot-uX0Vd23dN0nQW8Nrp2+E6gTFVN9TvLWHW7-cLw@mail.gmail.com
Whole thread Raw
In response to Re: not fetching all query results  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: not fetching all query results
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: not fetching all query results
Next
From: Radim Kolar
Date:
Subject: Re: not fetching all query results