Re: Out of memory error on huge resultset - Mailing list pgsql-jdbc

From nferrier@tapsellferrier.co.uk
Subject Re: Out of memory error on huge resultset
Date
Msg-id u7kgpxc2l.fsf@tapsellferrier.co.uk
Whole thread Raw
In response to Re: Out of memory error on huge resultset  (Dave Cramer <Dave@micro-automation.net>)
Responses Re: Out of memory error on huge resultset
List pgsql-jdbc
Dave Cramer <Dave@micro-automation.net> writes:

> No disadvantage, in fact that is what we would like to do.
>
>
> setFetchSize(size)  turns on cursor support, otherwise fetch
> normally

I love PostgreSQL's default behaviour: it's great to know
that a server side cursor resource is probably not hanging around for
simple querys.



Nic

pgsql-jdbc by date:

Previous
From: Jeffrey Duffy
Date:
Subject: Re: NullPointer error returned from ResultSet.java
Next
From: Dave Cramer
Date:
Subject: Re: Out of memory error on huge resultset