Re: OutOfMemory - Mailing list pgsql-jdbc

From Guido Fiala
Subject Re: OutOfMemory
Date
Msg-id 200404010951.10962.guido.fiala@dka-gmbh.de
Whole thread Raw
In response to Re: OutOfMemory  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: OutOfMemory
List pgsql-jdbc
Am Donnerstag, 1. April 2004 09:14 schrieb Oliver Jowett:
[...]
> > st=conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ
> >_ONLY); st.setFetchSize(1);
> >             ResultSet rs=st.executeQuery("Select * from tst_fetchsize");
> >             rs.last();//now we should be at "count"
>
> Indeed, here's your problem -- you're not allowed to call last() on a
> TYPE_FORWARD_ONLY resultset. The driver should throw an exception at
> this point (but currently doesn't). See the ResultSet.last() javadoc for
> details.

Ok - that's one part, but why does the second part of my testcase not work as
expected - means fetchsize has no effect ?

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: OutOfMemory
Next
From: Oliver Jowett
Date:
Subject: Re: OutOfMemory