@Override
	public String getListOfRecommendations() {
		String sql = SELECT_PROJECTS_FOR_TRAINING;
		List<Position> positions = new ArrayList<Position>();
		ResultSet resultSet = null;
		Statement statement = null;
		Connection connection = new DbConnection().getConnection();
		try {
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);

			while (resultSet.next()) {
				Position position = new Position();
				String positionId = resultSet.getString("position_id");
				String projectName = resultSet.getString("position_name");
				String projectStatus = resultSet.getString("status");
				String createdBy = resultSet.getString("createdBy");
				String recommendations = resultSet
						.getString("hr_recommendations");
				if (recommendations == null)
					recommendations = "";
				position.setCreatedBy(createdBy);
				position.setPositionId(positionId);
				position.setPositionName(projectName);
				position.setStatus(projectStatus);
				position.setRecommendation(recommendations);
				positions.add(position);
			}

		} catch (SQLException e) {
			m_logger.error(e.getMessage(), e);
		} finally {
			try {
				if (connection != null)
					connection.close();
				if (resultSet != null)
					resultSet.close();
				if (statement != null)
					statement.close();
			} catch (SQLException e) {
				m_logger.error(e.getMessage(), e);
			}
		}
		processProjectsForTraining(positions);
		return null;
	}