Re: Problems with big tables. - Mailing list 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