A.3.3 Programmatic Updates

Programmatic updates provide the ability to make updates using the JDBC API rather than SQL statements. The following interfaces have new methods and constants that support programmatic updates.

• ResultSet

• an updater method for updating each data type
• methods for inserting, deleting, or updating a row
• methods indicating whether a row was inserted, deleted, or updated
• method for cancelling a row update
• constants indicating the updatability of a result set

• DatabaseMetaData

• methods indicating the visibility of changes to a result set
• methods indicating whether a result set detects inserts, deletes, or updates
• method indicating whether the DBMS and driver support updatable result sets