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|