JDBC memory usage - Mailing list pgsql-jdbc

From Bill Schneider
Subject JDBC memory usage
Date
Msg-id 410156D7.50109@vecna.com
Whole thread Raw
Responses Re: JDBC memory usage
Re: JDBC memory usage
List pgsql-jdbc
Hello,

I noticed that I keep running out of memory when trying to run a query
that returns 100,000 rows or so.

Searching the archives, it seems that the JDBC driver reads the entire
ResultSet into memory at once rather than using cursors.  This is
definitely not the desired behavior for this particular query.

Has this been fixed recently?  I'm using PostgreSQL 7.3.4 with the
corresponding JDBC driver.

Thanks!

-- Bill
--
Bill Schneider
Chief Architect

Vecna Technologies
5004 Lehigh Rd., Suite B
College Park, MD 20740
bschneider@vecna.com
t: 301-864-7253 x1140
f: 301-699-3180


pgsql-jdbc by date:

Previous
From:
Date:
Subject: Re: Why Is pgSQL's JDBC Slow?
Next
From: jao@geophile.com
Date:
Subject: Re: JDBC memory usage