java.sql.SQLException: Invalid operation for read only resultset: updateSt
843854Jul 1 2003 — edited Aug 13 2003my code is
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM TBLATTACHMENTS where sr_no=1");
out.println(stmt.getResultSetConcurrency());
out.println(rs.getConcurrency());
In above code stmt.getResultSetConcurrency() returning 1008( int for CONCUR_UPDATABLE) . But rs.getConcurrency() is returning 1007 (int for CONCUR_READ_ONLY).
I am using oracle9i, jdk1.3, tomcat4.0, and oracle thin driver
pls tell me why stmt.executeQuery() returning read only ResultSet object