updating a CLOB field using oracle

[Rolf Johansson]

Hi:
I need to update a CLOB field in a table with JDBC, using Oracle. Here
is the code I have for retrieving the existing value and adding some more
text onto the CLOB:
try {
String stuff="XXXX";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select i, v from t where i='3' for update");
if (rs.next()) {
// clog is field #2
Clob clob = rs.getClob(2);
// concatenate the "stuff" String onto the existing value in the clob
((oracle.sql.CLOB)clob).putString(((oracle.sql.CLOB)clob).length()+1, stuff);
rs.updateRow();
}
}
When I run this I get the exception:
java.sql.SQLException: Invalid operation for read only resultset: updateRow
Sot what do I do with the clob in order to update the row?
TIA
- Rolf.

[Dana Hanna]

Look at the other "executeQuery" methods on the statement. You should see one that allows you to specify the ResultSet type.