Re: Problems with big tables.

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Jose Miguel Madinaveitia Ramirez <miguelmr(at)servidor(dot)unam(dot)mx>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems with big tables.
Date: 2004-08-06 22:10:16
Message-ID: 411401C8.2080109@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alexandre Aufrere 2004-08-07 08:41:25 Re: Problems with charsets, investigated...
Previous Message Oliver Jowett 2004-08-06 22:06:30 Re: Problems with charsets, investigated...