# JDBC BuildMap not reflected in account aggregation

**URL:** <https://developer.sailpoint.com/discuss/t/jdbc-buildmap-not-reflected-in-account-aggregation/32983>\
**Category:** SHF Discussion and Questions\
**Tags:** jdbc-connector, identity-security-cloud, rules\
**Created:** [March 1, 2024, 10:28am UTC](https://developer.sailpoint.com/discuss/t/jdbc-buildmap-not-reflected-in-account-aggregation/32983 "2024-03-01T10:28:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jolan](https://avatars.discourse-cdn.com/v4/letter/j/47e85d/32.png) [@jolan](https://developer.sailpoint.com/discuss/u/jolan)\
**Post date:** [March 1, 2024, 10:28am UTC](https://developer.sailpoint.com/discuss/t/jdbc-buildmap-not-reflected-in-account-aggregation/32983/1 "2024-03-01T10:28:13Z")

</div>

Hi,

I am writing a JDBC buildmap rule for remap all entitlements from a single table into seperate column.

Below is my code snippet

```auto
import sailpoint.connector.*;
import java.util.*;

    public boolean isNullOrEmpty(String str) {
        return str == null || str.isEmpty() || str.isBlank();
    }

        String ATTR_E_TYPE = "entitlement_type";
        String ATTR_E_NAME = "entitlement_name";

        String KEY_SECURITY_GROUP ...............

        Map map = JDBCConnector.buildMapFromResultSet(result, schema);
        String ent_type = (String) map.get(ATTR_E_TYPE);
        String ent_value = (String) map.get(ATTR_E_NAME);

        if(!isNullOrEmpty(ent_type) && !isNullOrEmpty(ent_value)){
		log.debug("[JDBCBuildMap - JDBC] for " + ent_type + " with value : " + ent_value);
            if(KEY_SECURITY_GROUP.equalsIgnoreCase(ent_type)){
				log.debug("[JDBCBuildMap - JDBC] - for " + KEY_SECURITY_GROUP + " with returned value : " + ent_type + ent_value);
                map.put(KEY_SECURITY_GROUP, ent_value);
            } else if (KEY_...............)

            map.remove(ent_type);
            map.remove(ent_value);
        }
        return map;

```

But based on ccg.log, I could not see whatever been set in BuildMap did not reflected in returnSet. (map)

---

<div class="post-metadata">

**Author:** ![RAKGDS](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/rakgds/32/2795_2.png) [@RAKGDS](https://developer.sailpoint.com/discuss/u/RAKGDS)\
**Post date:** [March 13, 2024, 4:00pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-buildmap-not-reflected-in-account-aggregation/32983/2 "2024-03-13T16:00:17Z")

</div>

Hi Joshua,  
Are you executing the entitlement aggregation and changing the values in there ?

Thanks  
Rakesh Bhati

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [May 12, 2024, 4:00pm UTC](https://developer.sailpoint.com/discuss/t/jdbc-buildmap-not-reflected-in-account-aggregation/32983/3 "2024-05-12T16:00:52Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.