Background documentation-10506: Result set type is READ_ONLY but row set type is UPDATABLE Locate this document in the navigation structure

 

Explanation

A RowSet could not be generated, because while the corresponding SQL statement allows updates (modifications), the result set type does not.

User Response

Result sets that cannot be modified can only be generated using special SELECT statements. The following options are available:

  • Alter the SQL statement

  • Set the result set type to CONCUR_READONLY using the SQLDBC_Statement::ConcurrencyType or SQLDBC_PreparedStatement::ConcurrencyType method. This generates a read-only result set.