Thread: Re: Postgresql 7.4.1 and JDBC setFetchSize
Re: Postgresql 7.4.1 and JDBC setFetchSize
From
curtis@stanfordcomputing.com (Curtis Stanford)
Date:
OK, I got it working by setting auto commit on the connection to
false. This should be made more clear in the docs...
curtis@stanfordcomputing.com (Curtis Stanford) wrote in message
news:<b1de01fc.0402041359.23f4dfc3@posting.google.com>...
> OK, I just installed 7.4.1 with the included JDBC driver so that I
> could use the new setFetchSize feature. I've been trying a query that
> returns over 300,000 rows which was running out of memory before. I
> added s.setFetchRows(50) and it still runs out of memory. Doesn't seem
> to make any difference. I'm just doing a very simple query thusly:
>
> Statement s = conn.createStatement();
> s.setFetchRows(50);
> ResultSet rows = s.executeQuery("...");
> while (rows.next()) {
> }
>
> I can't seem to get the CVS version of the JDBC driver either. The CVS
> web interface to postgresql has mentions of removing all JDBC code
> about 2 weeks ago. What's going on?
>
> Curtis
On 6 Feb 2004, Curtis Stanford wrote: > OK, I got it working by setting auto commit on the connection to > false. This should be made more clear in the docs... > > curtis@stanfordcomputing.com (Curtis Stanford) wrote in message news:<b1de01fc.0402041359.23f4dfc3@posting.google.com>... > > > > I can't seem to get the CVS version of the JDBC driver either. The CVS > > web interface to postgresql has mentions of removing all JDBC code > > about 2 weeks ago. What's going on? > > The driver is now being developed on gborg: http://gborg.postgresql.org/project/pgjdbc/projdisplay.php Kris Jurka