Re: ResultSet.updateString against DB2 giving "Column not updatable"



I just talked to an IBM support rep. DB2 supports updatable cursors,
and the universal driver supports updatable result sets, but somehow
the two don't get along:

"Updatable scrollable cursor is supported against z/OS V7, however,
only JDBC 1 styled positioned update is supported, not the JDBC 2
styled updates via the updateXXX methods. This is because extended
describe is not supported on z/OS V7 which is needed for the driver to
retrieve the table name in order to build the update statement
internally."

(This page says the universal driver supports updatable result sets.)
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvjcdif.htm

Positioned updates look rather strange, so I think I'll just go back to
a plain SELECT and UPDATE.

Thanks for your input.

.