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

Re: Problems with big tables.

From: Jose Miguel Madinaveitia Ramirez <miguelmr(at)servidor(dot)unam(dot)mx>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems with big tables.
Date: 2004-08-08 18:32:26
Message-ID: 411671BA.70806@servidor.unam.mx (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks to all for the help.
The problem is the autocommit status.

I change the values to off and the program work well ..



Oliver Jowett wrote:
> Jose Miguel Madinaveitia Ramirez wrote:
> 
>> Hi, I have a problem to obtain big tables (1 million records) with the 
>> jdbc driver.
>> The out of memory error is throw by the executeQuery().
>> The fetchsize() function does not work.?
> 
> 
> With the most current drivers, cursors will only be used to 
> incrementally fetch data when all of these conditions are true:
> 
>   - a positive fetchsize has been set via setFetchSize()
>   - autocommit is off
>   - the resultset type is TYPE_FORWARD_ONLY
>   - you are connecting to a 7.4 or above server
> 
> -O
> 
> 

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-08-08 23:16:09
Subject: patch: support unicode characters above U+10000
Previous:From: Justin Kennedy - Maritime SourceDate: 2004-08-08 14:28:43
Subject: Re: executing batch select queries

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