    All Packages    This Package  Previous  Next

# Interface sqlj.runtime.ForUpdate

public interface interface ForUpdate

An interface implemented by iterators which will be used in a positioned update or delete statement (as parameter to a WHERE CURRENT OF clause). Any iterator which is to be passed as a parameter to a WHERE CURRENT OF clause must implement this interface.

##

getCursorName()
  Get the name of the SQL cursor used by this iterator.

##

getCursorName

     public abstract String getCursorName() throws SQLException

  Get the name of the SQL cursor used by this iterator.

  In SQL, a result table is retrieved through a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name.

  SQLJ supports this SQL feature by providing the name of the SQL cursor used by an iterator. The current row of an iterator is also the current row of this SQL cursor.

  Note: If positioned update is not supported a SQLException is thrown

  Returns:
    the iterator's SQL cursor name
  Throws: SQLException
    if a database-access error occurs.

    All Packages    This Package  Previous  Next