Re: jdbc3 and ResultSet.getFetchSize()

On Tue, 26 Apr 2005, Michal Hlavac wrote:

> I have this code:
> ResultSet rs = stmt.executeQuery("SELECT attr FROM table WHERE id=1");
> System.out.println(rs.getFetchSize());
> 
> rs.getFetchSize() everytime returns 0... why???

The fetch size is a hint for the driver to know how many rows at a time to 
retrieve from the database.  If you haven't given the driver any hints it 
is set to zero meaning "If the fetch size specified is zero, the JDBC 
driver ignores the value and is free to make its own best guess as to what 
the fetch size should be."  Older drivers used to report the number of 
rows fetched in this method, but that was just an implementation artifact 
at best and a bug at worst.

Kris Jurka