I have
java codes like this:
String sql="select energy_etc.kwhexp from ...";
System.out.println(sql);
Statement kwhexp_stmt = conn.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet kwhexp_rs = kwhexp_stmt.executeQuery( sql);
double d=1.1;
while(kwhexp_rs.next()){
kwhexp_rs.updateDouble("kwhexp",d);
kwhexp_rs.updateRow();
d++;
}
When I execute these codes I got a error message:
Exception in
thread "main" java.sql.SQLException: Invalid operation for read onl
y resultset: updateDouble
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:229)
at oracle.jdbc.driver.BaseResultSet.updateDouble(BaseResultSet.java:225)
at oracle.jdbc.driver.OracleResultSet.updateDouble(OracleResultSet.java:2816)
at MonthlyBillGeneration.main(MonthlyBillGeneration.java:34)
What could be the reason I cannot update my result set?