In Derby, the functionality of updatable result sets in a server environment and in an embedded environment are similar, with the exception of the following differences:
select 1, 2 from t1 for update of c11The Network Client driver looks at both of the columns in the select list and cannot determine the target table for update/delete by looking at the column metadata. This requirement is not necessary in an embedded environment.
Other differences between updatable result sets in a server or embedded environment can be found in the following table.
Feature | Embedded Environment | Server Environment |
---|---|---|
updateBytes on CHAR, VARCHAR, LONG VARCHAR datatypes | Supported | Not supported |
updateTime on TIMESTAMP datatypes | Supported | Not supported |
updateClob and updateBlob | Supported | Not supported |