Result set update error

Question

I wrote a simple code for scrollable resultset.But it gives me an error. code: ``` import java.sql.*; import java.util.Properties; public class Scrollable_Resultset { public static void main(String[] args) throws Exception{ Properties p = new Properties(); p.put("user", "system"); p.put("password", "password"); DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe",p); Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("select * from EMPLOYEE"); System.out.println("Displaying all the rows of the result set forward"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getInt(3)); System.out.println("--------------"); }//end of while System.out.println("****************"); System.out.println("Printing resultset in reverse order"); rs.last();//go to las…

Accepted Answer

Reason is you are using `Select` query and trying to perform `Update` operation

```
ResultSet rs = stmt.executeQuery("select * from EMPLOYEE");
```

and another point is "SELECT *" makes Resultset as ReadOnly

If you want to perform update operation then you need to specify columns in the Select Query

Result set update error

Solution

Problem