public Q setFetchSize ( final int rows ) { checkNotClosed ( ) ; this . fetchSize = rows ; if ( statement != null ) { try { statement . setFetchSize ( fetchSize ) ; } catch ( SQLException sex ) { throw new DbSqlException ( this , "Unable to set fetch size: " + fetchSize , sex ) ; } } return _this ( ) ; }
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed . The number of rows specified affects only result sets created using this statement . If the value specified is zero then the hint is ignored . The default value is zero .