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)