Re: setFetchSize bug

>>
>> 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/[email protected]