Share via


Statement.setCursorName

Interface Overview | Interface Members | This Package | All Packages

Syntax

public abstract void setCursorName( String name ) throws SQLException

Parameters
  • name
    the new cursor name.
Description

setCursorname defines the SQL cursor name that will be used by subsequent Statement execute methods. This name can then be used in SQL positioned update/delete statements to identify the current row in the ResultSet generated by this statement. If the database doesn't support positioned update/delete, this method is a noop.

Note: By definition, positioned update/delete execution must be done by a different Statement than the one which generated the ResultSet being used for positioning. Also, cursor names must be unique within a Connection.

Exceptions

SQLException if a database-access error occurs.