Re: MySQL doesn't support fetch size

[Mark Matthews]

Andres,

The JDBC driver doesn't support it, because the MySQL protocol itself doesn't have the functionality.

Also notice that the JDBC API says it's a "hint" anyway, a driver is free to ignore the call to setFetchSize().

What exactly are you trying to do that requires you to .setFetchSize()? Often, needing to call .setFetchSize() is "hiding" a general issue with the approach to the problem you're trying to solve (because you're bringing back so many rows that it's required to "throttle" them, which more often than not means you're not thinking in a "database" way).

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html