title: SQL update Statement not changing record
body: <p>I have an sql update statement but I an't figure out why it doesn't update my records, it just does nothing, is there anything wrong with the syntax?</p>
  
  <pre><code>    private static final String strUpdatePerson =
          "UPDATE APP.PERSON " +
          "SET FIRSTNAME = ?, " +
          "    LASTNAME = ?, " +
          "    ADDRESS = ?, " +
          "    PHONE = ?, " +
          "    EMAIL = ?, " +   
          "    INFO = ? " +
          "WHERE ID = ?";
  </code></pre>
  
  <p>It's very confusing because there is no error given, it performs the update but changes nothing in the database.</p>
  
  <p>Edit:</p>
  
  <p>Here's the query being executed:</p>
  
  <pre><code>    stmtUpdateExistingRecord = dbConnection.prepareStatement(strUpdateCustomer);
  
  
      stmtUpdateExistingRecord.clearParameters();
          stmtUpdateExistingRecord.setString(1, record.firstName.toUpperCase());
          stmtUpdateExistingRecord.setString(2, record.lastName.toUpperCase());
          stmtUpdateExistingRecord.setString(3, record.Address);
          stmtUpdateExistingRecord.setString(4, record.phoneNumber);
          stmtUpdateExistingRecord.setString(5, record.email);
          stmtUpdateExistingRecord.setString(6, record.info);
          stmtUpdateExistingRecord.setInt(7, record.getID());
          stmtUpdateExistingRecord.executeUpdate();
  </code></pre>