Invalid operation for read only resultset: moveToInsertRow
843853Jul 19 2001 — edited Jul 23 2001I've some problem for updating resultset
I am using "oracle.jdbc.driver.OracleDriver" as the JDBC driver.
I've check the resultset type supported by the driver by useing
DBMetaData.supportsResultSetType
both ResultSet.TYPE_SCROLL_SENSITIVE and ResultSet.CONCUR_UPDATABLE are
supported
But when I call the following script
it said Invalid operation for read only resultset: moveToInsertRow
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("Select * from tbl_web_trx_hdr");
ResultSet rs = stmt.executeQuery("Select * from tbl_org_idx");
rs.moveToInsertRow();
rs.insertRow();
rs.updateString(1, "ABCTEST");
rs.updateRow();
Please help
regards,
Fannie