title: Result Set not updateable when I use updateable field
body: <p>I am running this code but I don't know what is wrong in this code.</p>
  <p>I define the statement with field SENSITIVE &amp; UPDATABLE but when I run the code this error message appears in the console:</p>
  <blockquote>
  <p>Result Set not updatable.This result set must come from a statement
  that was created with a result set type of ResultSet.CONCUR_UPDATABLE,
  the query must select only one table, and must select all primary keys
  from that table.</p>
  <p>See the JDBC 2.1 API Specification,  section 5.6 for
  more details.</p>
  <p>Process finished with exit code 0</p>
  </blockquote>
  <p>Please guide me. Here is the code:</p>
  <pre><code>import java.sql.*;
  
  
  public class Main
  {
  
  public static void main(String[] args)
  {
      Connection con=getConnection();
  
      try
      {
          String query=&quot;Select title from movie1&quot;;
          Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
          ResultSet rs=stmt.executeQuery(query);
          rs.absolute(13);
          rs.deleteRow();
  
      }
      catch (SQLException e)
      {
         System.out.println(e.getMessage());
      }
  
  }
  
  private static Connection getConnection()
  {
      Connection con=null;
      try
      {
          Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
          String url=&quot;jdbc:mysql://localhost/Movies&quot;;
          String user=&quot;user4545&quot;;
          String pw=&quot;j4545j&quot;;
          con= DriverManager.getConnection(url,user,pw);
      }
      catch (ClassNotFoundException e)
      {
          System.out.println(e.getMessage());
          System.exit(0);
      }
      catch (SQLException e)
      {
          System.out.println(&quot;SQL Exeption happend.&quot;);
          System.exit(0);
      }
      return con;
  }
  }
  </code></pre>