@Override
 public List<Choice> getQuestionChoices(int id) {
   List<Choice> list = new ArrayList<Choice>();
   try {
     Question question = this.loadQuestion(id);
     if (null != question) {
       list = question.getChoices();
     }
   } catch (Throwable t) {
     _logger.error("Error while loading the choices belonging to the question of ID {}", id, t);
     throw new RuntimeException("Error while loading the choices belonging a question", t);
   }
   return list;
 }
 @Override
 public Question loadQuestion(int id) {
   Question question = null;
   Connection conn = null;
   PreparedStatement stat = null;
   ResultSet res = null;
   try {
     conn = this.getConnection();
     stat = conn.prepareStatement(GET_COMPLETE_QUESTION_BY_ID);
     stat.setInt(1, id);
     res = stat.executeQuery();
     while (res.next()) {
       if (null == question) {
         question = this.buildQuestionRecordFromResultSet(res, 1);
       }
       // get extra info: questions need the survey type
       int questionnaireValue = res.getInt(13);
       boolean questionnaire = questionnaireValue == 1 ? true : false;
       ApsProperties titles = new ApsProperties();
       titles.loadFromXml(res.getString(14));
       question.setExtraInfo(questionnaire, titles);
       Choice choice = this.buildChoiceRecordFromResultSet(res, 8);
       if (null == choice) continue;
       choice.setExtraInfo(
           question.getSurveyId(),
           question.isQuestionnaire(),
           question.getSurveyTitles(),
           question.getQuestions());
       if (null == question.getChoice(choice.getId())) {
         question.getChoices().add(choice);
       }
     }
   } catch (Throwable t) {
     _logger.error("Error while loading the question of ID {}", t);
     throw new RuntimeException("Error while loading a question", t);
   } finally {
     closeDaoResources(res, stat, conn);
   }
   return question;
 }