Re: JDBC memory usage - Mailing list pgsql-jdbc

From jao@geophile.com
Subject Re: JDBC memory usage
Date
Msg-id 1090607761.41015a91d8bd8@geophile.com
Whole thread Raw
In response to JDBC memory usage  (Bill Schneider <bschneider@vecna.com>)
List pgsql-jdbc
Quoting Bill Schneider <bschneider@vecna.com>:

> 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.

I ran into this problem. The driver developers informed me that
this problem is fixed in 7.4, and that the new driver can be used
with a 7.3 server. (This exchange should be in the pgsql-jdbc
archives.)

Jack Orenstein

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

pgsql-jdbc by date:

Previous
From: Bill Schneider
Date:
Subject: JDBC memory usage
Next
From: Yi LIN
Date:
Subject: conflict txns in serialization isolation