Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Result Set Related Problem

 
Prakash Rai
Ranch Hand
Posts: 106
Eclipse IDE MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator




1. When I am Connection with Mysql its is working fine.
2. But In case of Oracle10 it is giving Problem Even though result Set is of Updatable type.

java.sql.SQLException: Invalid operation for read only resultset: moveToInsertRow
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.BaseResultSet.moveToInsertRow(BaseResultSet.java)
at com.p14.test.main(test.java:38)


Please someone go through it.. Thanks In advance...
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Prakash,
Please refer to Oracle documentation for the database you are using.
There should be a book entitled "JDBC Developer's Guide".
In that book there should be a section entitled "Resultset Limitations and Downgrade Rules".
You should find there an explanation for the behaviour you describe.

Good Luck,
Avi.
 
sai rama krishna
Ranch Hand
Posts: 432
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you running trhough IDE. Try to put a break point and identify where the error is exactly coming and modify code if needed to suit oracle database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic