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