}
public int insertCandidateChore(String choreName) throws Exception {
Chore chore = selectChore(choreName);
if (chore == null)
throw new NameNotFoundException(choreName);
String insertSql = "INSERT INTO candidate_chores (id, name) VALUES(?,?)";
PreparedStatement insertStatement = null;
int nn = 0;
long id = Common.getUniqueIdNumber();