October 24, 2008 at 2:47 PM
The "fetch size" is a hint to the driver to control internal buffering within the driver.
It has absolutely no effect on the number of rows in a ResultSet. The driver is also free to ignore the hint.
A "fetch size" of 0 means "transfer all rows in the result from the database to the Java client at once, i.e. no buffering". It is the default for some drivers, and not for others.