title: java.sql.SQLException: No value specified for parameter 1
body: <p>I have looked at other stackoverflow threads to get an answer for this problem.  Mostly what I see is that it is caused by typos, although I cannot see any in this method.  This method is called from another method in the same class and when run returns the error :</p>
  
  <p>java.sql.SQLException: No value specified for parameter 1</p>
  
  <p>The code for my class is here:</p>
  
  <pre><code>public void WriteTag(String tagPrefix, String tagName, String tagContent)
  {
      try {
          String query = String.format("INSERT INTO %s(%s,%s) VALUES(?,?)", 
                  tagPrefix, TAGNAME_COLUMN, TAGCONTENT_COLUMN);
          PreparedStatement sqlStatement = connection.prepareStatement(query);
          sqlStatement.setString(1, tagName);
          sqlStatement.setString(2, tagContent);
          //sqlStatement.executeUpdate();
      } catch(Exception e) {HandleException(e);}
  }
  </code></pre>
  
  <p>I'm not really sure what is wrong here.  The constants are properly defined elsewhere in the code.  Does anyone see what I am doing wrong?</p>