• Post Reply Bookmark Topic Watch Topic
  • New Topic

problem with oracle8i with TYPE- 4 DRIVER

 
ramchander yshetti
Ranch Hand
Posts: 97
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hai,
i am getting a problem with moveToInsertRow() method (using type-4 driver)
and it is working with (type-1 driver).


the following error has occured during running the program

rs.moveToInsertRow()

Invalid operation for read only resultset : moveToInsertRow()

At oracle.jdbc.dbaccess.DBError.thorwSqlException(DBError.java:134);
At oracle.jdbc.dbaccess.DBError.thorwSqlException(DBError.java:179);

At oracle.jdbc.driver.BaseResultSet .moveToInsertRow(BaseResultSet.java :593);
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36031
432
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yathamshetti,
The error message states your result set is read only. This means you either need to run the query with different flags or your driver doesn't support updatable resultsets.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!