# Unable to make the account status as disabled for oraclejdbc **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** aggregation, sailpoint-identity-security\ **Created:** [November 11, 2025, 10:29am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964 "2025-11-11T10:29:12Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Tulasi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/tulasi/32/34596_2.png) [@Tulasi](https://developer.sailpoint.com/discuss/u/Tulasi)\ **Post date:** [November 11, 2025, 10:29am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/1 "2025-11-11T10:29:12Z")
Hello Experts, I was trying to make the account status for the jdbc accounts as disabled, without using the jdbc buildmap rule , with the use of making account query as SELECT \*, CASE WHEN user.status = 0 THEN 1 ELSE 0 END AS IIQDisabled FROM user LEFT JOIN usercapabilities ON user.userid = usercapabilities.userid ORDER BY user.userid; my database is oracle jdbc and I have added the IIQDisabled attribute to the schema and made it as boolean but it was not working as expected , the value was not getting populated in the IIQDisabled attribute and the account status is being enabled only. can someone help me out with this, It will be very helpful Thanks in advance! Tulasi ---
**Author:** ![JackSparrow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/jacksparrow/32/19685_2.png) [@JackSparrow](https://developer.sailpoint.com/discuss/u/JackSparrow)\ **Post date:** [November 11, 2025, 11:02am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/2 "2025-11-11T11:02:55Z")
Hi @Tulasi , Please find below query. Adjust ‘true’ / ‘false’ based on the status code. Keep IIQDisabled type as “string” in schema CASE WHEN user.status = ‘0’ THEN ‘true’ ELSE ‘false’ END AS IIQDisabled, ---
**Author:** ![Tulasi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/tulasi/32/34596_2.png) [@Tulasi](https://developer.sailpoint.com/discuss/u/Tulasi)\ **Post date:** [November 11, 2025, 11:10am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/3 "2025-11-11T11:10:05Z")
Hi @JackSparrow We tried this approach but it didn’t work Thanks for the response ---
**Author:** ![chaithu979](https://avatars.discourse-cdn.com/v4/letter/c/f0a364/32.png) [@chaithu979](https://developer.sailpoint.com/discuss/u/chaithu979)\ **Post date:** [November 11, 2025, 11:42am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/4 "2025-11-11T11:42:13Z")
If you’re okay with using a **JDBC BuildMap rule** , you can achieve the `IIQDisabled` mapping reliably using the following code snippet: import sailpoint.connector.\*; import java.util.Map; Map map = JDBCConnector.buildMapFromResultSet(result, schema); if (map.containsKey(“active”) && map.get(“active”) != null) { // Step 1: Get the boolean value boolean isActive = (Boolean) map.get(“active”); // Step 2: Convert to disabled flag if (!isActive) { map.put(“IIQDisabled”, true); } else { map.put(“IIQDisabled”, false); } } return map; This ensures: - If `active = false` → `IIQDisabled = true` (account shown as disabled in IIQ) - If `active = true` → `IIQDisabled = false` ---
**Author:** ![Tulasi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/tulasi/32/34596_2.png) [@Tulasi](https://developer.sailpoint.com/discuss/u/Tulasi)\ **Post date:** [November 11, 2025, 11:49am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/5 "2025-11-11T11:49:44Z")
Thanks for the response but the account attribute we use for the status mapping is status which is number not string, so not sure whether the above buildmap works are should we make any changes to it ---
**Author:** ![chaithu979](https://avatars.discourse-cdn.com/v4/letter/c/f0a364/32.png) [@chaithu979](https://developer.sailpoint.com/discuss/u/chaithu979)\ **Post date:** [November 11, 2025, 11:51am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/6 "2025-11-11T11:51:40Z")
import sailpoint.connector.\*; import java.util.Map; Map map = JDBCConnector.buildMapFromResultSet(result, schema); if (map.containsKey(“status”) && map.get(“status”) != null) { int status = 0; try { status = Integer.parseInt(map.get(“status”).toString()); } catch (Exception e) { status = 0; // default fallback } // Assuming 0 = disabled and 1 = active if (status == 0) { map.put(“IIQDisabled”, true); } else { map.put(“IIQDisabled”, false); } } return map; ---
**Author:** ![fayadm](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@fayadm](https://developer.sailpoint.com/discuss/u/fayadm)\ **Post date:** [December 9, 2025, 10:17am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/7 "2025-12-09T10:17:37Z")
JDBCConnector.buildMapFromResultSet(result, schema) is not working anymore. The Java Doc does not list JDBCConnector under classes anymore unlike DelimitedFileConnector and I can not access the class in my IDE. Is there a way to access call the method buildMapFromResultSet in a BuildMap rule? ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [February 7, 2026, 10:18am UTC](https://developer.sailpoint.com/discuss/t/unable-to-make-the-account-status-as-disabled-for-oraclejdbc/187964/8 "2026-02-07T10:18:32Z")
Closed on February 7, 2026, 10:18am UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.