Re: ResultSet.updateString against DB2 giving "Column not updatable"
- From: adamcrume@xxxxxxxxx
- Date: 29 Jun 2006 13:08:35 -0700
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.
.
- References:
- ResultSet.updateString against DB2 giving "Column not updatable"
- From: adamcrume
- Re: ResultSet.updateString against DB2 giving "Column not updatable"
- From: Joe Weinstein
- Re: ResultSet.updateString against DB2 giving "Column not updatable"
- From: adamcrume
- Re: ResultSet.updateString against DB2 giving "Column not updatable"
- From: joeNOSPAM@xxxxxxx
- Re: ResultSet.updateString against DB2 giving "Column not updatable"
- From: adamcrume
- Re: ResultSet.updateString against DB2 giving "Column not updatable"
- From: joeNOSPAM@xxxxxxx
- ResultSet.updateString against DB2 giving "Column not updatable"
- Prev by Date: Re: ResultSet.updateString against DB2 giving "Column not updatable"
- Next by Date: Re: DB2 "Pasword expired" and "pasword soon to expire" detection from java
- Previous by thread: Re: ResultSet.updateString against DB2 giving "Column not updatable"
- Index(es):