public static Petition getPetition(int id) throws ESellException {

		makeConnection();
		PreparedStatement preparedStatement = null;

		if (conn != null) {
			try {

				// Statement vorbereiten
				// Statement luft mit INNER JOIN, damit man den Kategorienamen
				// gleich mitkriegt.
				String sql = "SELECT * FROM petitions WHERE (id=?)";
				preparedStatement = conn.prepareStatement(sql);
				preparedStatement.setInt(1, id);

				// Statement absetzen
				ResultSet result = preparedStatement.executeQuery();

				// Objektmapping
				if (result.next()) {
					
					return new Petition(result);
							
				}
				else
					throw new ESellException(ESellException.ErrorCode.NO_ENTRY_ERR);
			} catch (SQLException e) {
				// ToDo
				e.printStackTrace();
				throw new ESellException(ESellException.ErrorCode.DB_ERR);
			}
		}
		else
			throw new ESellException(ESellException.ErrorCode.DB_ERR);
	}