setFetchSize Method (SQLServerResultSet)

DownloadDownload JDBC Driver

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 SQLServerResultSet object.

Syntax

  
public void setFetchSize(int rows)  

Parameters

rows

An int indicating the number of rows to fetch.

Exceptions

SQLServerException

Remarks

This setFetchSize method is specified by the setFetchSize method in the java.sql.ResultSet interface.

If the fetch size specified is zero, the JDBC driver ignores the value and estimates what the fetch size should be. The default value is set by the SQLServerStatement object that created the result set. The fetch size can be changed at any time.

This method changes the block fetch size for server cursors, and takes effect the next time the JDBC driver needs to call sp_cursorfetch. Setting the fetch size to zero restores the default fetch size for the cursor type that is currently in use

See Also

SQLServerResultSet Members
SQLServerResultSet Class