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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2004-08-08 23:16:09 | patch: support unicode characters above U+10000 |
Previous Message | Justin Kennedy - Maritime Source | 2004-08-08 14:28:43 | Re: executing batch select queries |