setFetchSize(int rows)

Syntax:

void setFetchSize(int rows)
                  throws SQLException

Description:

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.

Parameters:

rows

the number of rows to fetch

Throws:

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.

Reference:

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