class ToolGroupDao extends NamedParameterJdbcDaoSupport {

    @Transactional(propagation = Propagation.SUPPORTS)
    public Optional<ToolGroup> loadToolGroup(Long id) {
        return getJdbcTemplate().query(loadToolGroupQuery, ToolGroupParameters.getRowMapper(), id).stream().findFirst();
    }

}