 | | | 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:
Whoops, forgot to paste the URL, here it is:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation
-notes.html
-Mark
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=mysql@(protected)
|
|
|