Hi,
Which driver should I use? Because when I do what you suggested, I get
"This method is not yet implemented" ... stmt.setFetchSize(1000).
I am using the official postgresql-8.1-404.jdbc3.jar driver.
Many thanks.
Khaldoun
-----Original Message-----
From: Roland Walter [mailto:rwa@mosaic-ag.com]
Sent: Thursday, January 05, 2006 1:15 PM
To: Khaldoun Ateyeh
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] table full scan
"Khaldoun Ateyeh" <Khaldoun.Ateyeh@panoratio.de> writes:
> Hi,
> I am using jdbc to full scan a huge table (over 11 million records).
> Unfortunately, I get an OutOfMemoryError exception. Is there any way
to
> tell postgre not to try to load the whole table at once?
>
Set autocommit to false, then use the method setFetchSize() of
the Statement to set the maximal rows that are read into the memory.
For example:
con.setAutoCommit(false);
stmt = con.createStatement();
stmt.setFetchSize(1000);
--
Roland Walter mailto: rwa (at) mosaic-ag (dot) com
MOSAIC SOFTWARE AG phone: +49 (0) 22 25 / 88 2-41 1
Am Pannacker 3 fax: +49 (0) 22 25 / 88 2-20 1
D-53340 Meckenheim http://www.mosaic-ag.com