Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid operation for read only resultset: moveToInsertRow

843853Jul 19 2001 — edited Jul 23 2001
I'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



Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2001
Added on Jul 19 2001
14 comments
2,959 views