fetchsize dynamically changeable? - Mailing list pgsql-jdbc

From Guido Fiala
Subject fetchsize dynamically changeable?
Date
Msg-id 200407280839.56336.guido.fiala@dka-gmbh.de
Whole thread Raw
Responses Re: fetchsize dynamically changeable?
Re: fetchsize dynamically changeable?
List pgsql-jdbc
Given all the other requirements for cursors are met, is it possible to change
the fetchsize on the fly?

e.g.
conn.createStatement(...);
st.setFetchsize(1);
rs=st.executeQuery(...);//we got the first record
st.setFetchsize(10);
rs.next(); //now we got records nr. 2-11 in memory and sit at nr. 2

BTW - how is FETCH BACKWARD, what needs to be done to get it working?

pgsql-jdbc by date:

Previous
From: "j.random.programmer"
Date:
Subject: Bug in 7.4_213 driver: returns VARCHAR instead of LONGVARCHAR for text types
Next
From: Oliver Jowett
Date:
Subject: Re: fetchsize dynamically changeable?