Skip site navigation (1) Skip section navigation (2)

Re: not fetching all query results

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Radim Kolar <hsn(at)filez(dot)com>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: not fetching all query results
Date: 2012-07-17 18:48:09
Message-ID: CADK3HH+HEot-uX0Vd23dN0nQW8Nrp2+E6gTFVN9TvLWHW7-cLw@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)fastcrypt(dot)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(at)filez(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc

In response to

Responses

pgsql-jdbc by date

Next:From: Radim KolarDate: 2012-07-17 19:49:00
Subject: Re: not fetching all query results
Previous:From: Dave CramerDate: 2012-07-17 18:28:10
Subject: Re: not fetching all query results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group