public Category find(String CategoryId) throws InstanceNotFoundException {

		Category category = null;

		try {
			Connection connection = DataSourceUtils.getConnection(dataSource);

			PreparedStatement statement = connection
					.prepareStatement("SELECT genre FROM Category WHERE genre = ?");
			statement.setString(1, CategoryId);

			ResultSet resultSet = statement.executeQuery();

			if (resultSet.next()) {
				String genre = resultSet.getString(1);
				category = new Category(CategoryId);
			} else {
				throw new InstanceNotFoundException();
			}
			//connection.close();
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}

		return category;
	}