Edit

setFetchDirection Method (SQLServerResultSet)

  • Article

Download JDBC driver

Gives a hint as to the direction in which the rows in this SQLServerResultSet object will be processed.

Note

This method is not currently supported by the Microsoft JDBC Driver for SQL Server. If you use this method, the JDBC driver remembers the setting, but currently does not act on it.

Syntax

  
public void setFetchDirection(int direction)

Parameters

direction

An int that indicates the suggested fetch direction. Can be one of the following values:

ResultSet.FETCH_FORWARD

ResultSet.FETCH_REVERSE

ResultSet.FETCH_UNKNOWN

Exceptions

SQLServerException

Remarks

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

The initial value of this method is determined by the SQLServerStatement object that produced this SQLServerResultSet object. The fetch direction can be changed at any time.

Note

Using this method when the cursor type is forward-only has no effect.

See Also

SQLServerResultSet Members
SQLServerResultSet Class