class JDBCConnection implements ObjectStoreConnection {

    @Override
    public List<PrincipalGroup> listGroupsWithUserAuthorityRestrictions() {

        final String caller = "listGroupsWithUserAuthorityRestrictions";
        List<PrincipalGroup> groups = new ArrayList<>();
        try (PreparedStatement ps = con.prepareStatement(SQL_LIST_GROUPS_WITH_RESTRICTIONS)) {

            try (ResultSet rs = executeQuery(ps, caller)) {
                while (rs.next()) {
                    PrincipalGroup group = new PrincipalGroup();
                    group.setDomainName(rs.getString(ZMSConsts.DB_COLUMN_AS_DOMAIN_NAME));
                    group.setGroupName(rs.getString(ZMSConsts.DB_COLUMN_AS_GROUP_NAME));
                    group.setDomainUserAuthorityFilter(rs.getString(ZMSConsts.DB_COLUMN_AS_DOMAIN_USER_AUTHORITY_FILTER));
                    groups.add(group);
                }
            }
        } catch (SQLException ex) {
            throw sqlError(ex, caller);
        }

        return groups;
    }

    public  JDBCConnection(Connection con, boolean autoCommit);

}