deletesAreDetected Method (SQLServerDatabaseMetaData)
Retrieves whether or not a visible row delete can be detected by calling the rowDeleted method of the SQLServerResultSet class.
Syntax
public boolean deletesAreDetected(int type)
Parameters
type
An int that indicates the result set type, which can be one of the following values as defined in java.sql.ResultSet or SQLServerResultSet:
java.sql.ResultSet Types
TYPE_FORWARD_ONLY
TYPE_SCROLL_SENSITIVE
TYPE_SCROLL_INSENSITIVE
SQLServerResultSet Types
TYPE_SS_SCROLL_STATIC
TYPE_SS_SCROLL_KEYSET
TYPE_SS_DIRECT_FORWARD_ONLY
TYPE_SS_SERVER_CURSOR_FORWARD_ONLY
TYPE_SS_SCROLL_DYNAMIC
Return Value
true if a hole replaces the deleted row. false if the deleted row is removed.
When using the Microsoft SQL Server JDBC Driver with a SQL Server database, this method returns true for TYPE_SS_SCROLL_KEYSET cursors and false for all other result set types.
Exceptions
Remarks
This deletesAreDetected method is specified by the deletesAreDetected method in the java.sql.DatabaseMetaData interface.
Note
SQL Server detects deleted rows for all updatable cursor types, although the detection is transient for forward and dynamic cursors.
See Also
Reference
SQLServerDatabaseMetaData Class