setFetchSize(int rows)


void setFetchSize(int rows)
                  throws SQLException


Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.



the number of rows to fetch


SQLException - if a database access error occurs, rows is less than zero or greater than the maximum rows that this result set was created with (see Statement.setMaxRows), or this method is called on a closed result set.


For more information, reference JDBC documentation for: ResultSet.setFetchSize(int)