When I run the code below, I am getting exception "Invalid operation for read only resultset: updateFloat" although I am using updatable resultset. Any idea what's causing this? [I am using jdk1.5.0. However, Oracle
jdbc driver I am using is meant for jdk1.4]
...Code Snippet ...
Statement stmt = tOra3.myConn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet srs = stmt.executeQuery("SELECT * FROM EMP");
while(srs.next()) {
if (srs.getString("ENAME").equalsIgnoreCase("SATISH")) {
srs.updateFloat("ENAME",10000);
srs.updateRow();
tOra3.myConn.commit();
break;
}
}
....Complete Code...
import java.sql.*;
public class TestOracle3 {
Connection myConn= null;
/** Creates a new instance of TestOracle3 */
public TestOracle3() {
try {
Class.forName("oracle.jdbc.OracleDriver");
myConn = DriverManager.getConnection(
"jdbc

racle:thin:@sattiku:1521:satish",
"scott",
"tiger");
myConn.setAutoCommit(false);
} catch(ClassNotFoundException cnfe) {
System.out.println(cnfe.getMessage());
} catch(SQLException sqle) {
System.out.println(sqle.getMessage());
}
}
public static void main(
String[] args) {
TestOracle3 tOra3 = new TestOracle3();
try {
Statement stmt = tOra3.myConn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet srs = stmt.executeQuery("SELECT * FROM EMP");
while(srs.next()) {
if (srs.getString("ENAME").equalsIgnoreCase("SATISH")) {
srs.updateFloat("ENAME",10000);
srs.updateRow();
tOra3.myConn.commit();
break;
}
}
srs.close();
tOra3.myConn.close();
} catch(SQLException sqle) {
System.out.println("SQL Exception: " + sqle.getMessage());
}
}
}