title: Freeze a gui jdbc ,when save a data,why?
body: <p>Hy i create one project (i maked using this turtorial: <a href="http://www.homeandlearn.co.uk/java/save_a_new_record.html" rel="nofollow">http://www.homeandlearn.co.uk/java/save_a_new_record.html</a>  using this database: <a href="http://www.homeandlearn.co.uk/java/java_and_databases.html" rel="nofollow">http://www.homeandlearn.co.uk/java/java_and_databases.html</a>)</p>
  
  <p>When I want to save new record the program is freezing.(I want to when I save a new data the program will able to wrok with next and prev buttons)</p>
  
  <p>The save_button i changed with these code:</p>
  
  <pre><code>private void btnSaveRecordActionPerformed(java.awt.event.ActionEvent evt) {
      //...................................................................................
      String first = textFirstName.getText();
      String last = textLastName.getText();
      String job = textJobTitle.getText();
      String ID = textID.getText();
      int newID = Integer.parseInt(ID);
  
      try {
          String insertSql = "INSERT INTO Workers (ID,FIRST_NAME,LAST_NAME,JOB_TITLE) VALUES(" + newID + ",'" + first + "','" + last + "','" + job + "')";
          stmt.executeUpdate(insertSql);
  
  
          rs.next();
          int id_col = rs.getInt("ID");
          String id = Integer.toString(id_col);
          String first2 = rs.getString("First_Name");
          String last2 = rs.getString("Last_Name");
          String job2 = rs.getString("Job_Title");
  
          textID.setText(id);
          textFirstName.setText(first2);
          textLastName.setText(last2);
          textJobTitle.setText(job2);
  
      } catch (SQLException err) {
          System.out.println(err.getMessage());
      }
  </code></pre>
  
  <p>(cleared the blocking segment(false,trues..) but now I have this error: </p>
  
  <blockquote>
    <p>ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.</p>
  </blockquote>
  
  <p>)</p>