  | | | setFetchSize bug | setFetchSize bug 2007-11-11 - By Mark Matthews
Back > > If I have a ResultSet on table 't' with field 's', then I can call > ResultSet.getString("t.s"). But if I first call Statement.setFetchSize() > then this field isn't found.
Fschmidt,
That seems like a bug, but I haven't seen it in practice. Do you have a more complete testcase you could file as a bug at http://bugs.mysql.com/?
Code inspection shows that setFetchSize() is a no-op unless it's set to Integer.MIN_VALUE, or if "useCursorFetch=true" has been set on the URL (the default is false).
> > Calling ResultSet.setFetchSize() doesn't work at all (doesn't set the > fetch > size).
MySQL doesn't have a concept of fetching rows by chunks. This is documented in the manual for Connector/J here:
-Mark
-- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/java?unsub=mysql@(protected)
|
|
 |