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

Re: Postgresql 7.4.1 and JDBC setFetchSize

From
Kris Jurka
Date:

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