refreshRow Method (SQLServerResultSet)

Download JDBC driver

Refreshes the current row with its most recent value in the database.

Syntax

  
public void refreshRow()  

Exceptions

SQLServerException

Remarks

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

This method cannot be called when the cursor is on the insert row.

This method provides a way for an application to explicitly tell the JDBC driver to refetch rows from the database. An application might need to call this method when the Microsoft JDBC Driver for SQL Server is caching or prefetching to fetch the latest value of a row from the database. The JDBC driver might actually refresh multiple rows at the same time if the fetch size is greater than one.

All values are refetched subject to the transaction isolation level and cursor sensitivity. If this method is called after calling an updater method, but before calling the updateRow method, the updates made to the row are lost. Calling this method frequently will probably slow performance.

See Also

SQLServerResultSet Members
SQLServerResultSet Class