Freeze a gui jdbc ,when save a data,why?
<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>
