how to change string datatype to json datatype in DS

Tagged: , ,

This topic has 3 replies, 3 voices, and was last updated 4 months, 2 weeks ago by sahoob.

  • Author
    Posts
  • #26148
     sahoob
    Participant

    Hi,

    We have few json data are stored on string data type (SYNTAX 1.3.6.1.4.1.1466.115.121.1.15) field on DJ 3.5. Could it possible to change the data type of those fields to json datatype (SYNTAX 1.3.6.1.4.1.1466.115.121.1.5)?

    Regards,
    Biswajit

    #26149
     JnRouvignac
    Participant

    Hello,

    1.3.6.1.4.1.1466.115.121.1.5 is binary syntax, i.e. not what you want.
    Json syntax is only implemented since 4.0 if I remember correctly. The OID is 1.3.6.1.4.1.36733.2.1.3.1.

    Are the current data using a valid JSON format?

    In that case it is possible to change the schema without problem. Note that you may also have to change the equality matching rule: to EQUALITY caseIgnoreJsonQueryMatch.

    Jean-Noel

    #26150
     Ludo
    Moderator

    The syntax 1.3.6.1.4.1.1466.115.121.1.5 is Binary, and not related to JSON datatypes.
    Changing the syntax for an existing attribute is possible but not recommended.
    There could be side effects such as requiring to rebuild indexes if there are any index, but also possibly the inability to delete specific values (if they are not fully compliant with the JSON syntax).

    #26151
     sahoob
    Participant

    Thanks Jean-Noel and Ludo,

    Sorry wrongly copy/paste the OID for json. yes the correct one is 1.3.6.1.4.1.36733.2.1.3.1
    Yes our data is valid json format and currently no index is defined for those data.

    So if we change the datatype on this data set. does you see any impact? or its recommend to continue using on the string datatype?

    Regards,
    Biswajit

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

©2019 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?