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

Updating a ResultSet object..

rajesh madhira
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The following piece of code prints out a "YES" on the console but when i try to update the ResultSet object rs, i get an Exception saying

YES"java.sql.SQLException: Invalid operation for read only resultset : updateBoolean at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.driver.BaseResultSet.updateBoolean(
at org.apache.commons.dbcp.DelegatingResultSet.updateBoolean("

The code follows:

conn = querySession.getConnection();
DatabaseMetaData dmd = conn.getMetaData();
ResultSet rs = preparedStatement.executeQuery(query);

can somebody help me out....??

Rajesh Madhira
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic