Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-14625

Oracle repo fails when trying to update a managed object with a property typed as ['number', 'null']

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Expired
    • Affects Version/s: 6.5.0.2
    • Fix Version/s: None
    • Component/s: _Update
    • Labels:
    • Environment:
      IDM 6.5.0.2 with Oracle Repo using explicit repositories
    • Target Version/s:
    • Support Ticket IDs:
    • Zendesk ID:
      #48803

      Description

      Using explicit repositories and an oracle database. When trying to update a managed object with a property typed as ['number', 'null'] you will get an error:  

      Caused by: java.lang.NullPointerException

      at org.forgerock.openidm.repo.jdbc.impl.query.TracedPreparedStatement.setObject(TracedPreparedStatement.java:218)

      at org.forgerock.openidm.repo.jdbc.impl.ExplicitTableHandler.populatePrepStatementColumns(ExplicitTableHandler.java:401) 

       

      After further investigation, it was found that in ExplicitTableHandler.java, the numbers can't be null even though explicitly set the type to ['number', 'null']

       

      Attribute as defined in the managed.json configuration file:

      "accessTokenLifetime" : {
      "title" : "Access Token Lifetime",
      "description" : "Allow to set a custom access token lifetime for this client (0 use the OpenAM OAuth2Provided default one)",
      "viewable" : true,
      "searchable" : false,
      "userEditable" : false,
      "minLength" : null,
      "type" : [
      "number",
      "null"
      ],
      "isVirtual" : false
      }
      

       

       The issue appears that number can't be NULL anymore on the 6.5.X version of IDM.

        Attachments

          Activity

            People

            • Assignee:
              ramya.srinivassan Ramya Srinivassan
              Reporter:
              simon.wickham Simon Wickham
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: