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

databaseName in datasource json is actually schema name for some DBs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: OpenIDM 6.0.0, 6.5.0
    • Fix Version/s: 7.1.0
    • Component/s: documentation
    • Labels:
      None
    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      1
    • Sprint:
      2020.15 - IDM
    • Support Ticket IDs:

      Description

      The "databaseName" parameter (in datasource...json) is actually used as the schema name in parameterised queries ("${_dbSchema}" in repo.jdbc.json) for PostgreSQL and Oracle DB.

      At the moment, the install guide has no explanation of how "databaseName" is used.
      The integrator's guide has:
      [https://backstage.forgerock.com/docs/idm/6.5/integrators-guide/#datasource-jdbc-json
      ]

      databaseName
      The name of the database to which IDM connects. By default, this is openidm.

      This may be true for some DBs, but not for PostgreSQL, Oracle (and possibly others).

      It would be helpful to document, for each DB, what the "databaseName" parameter means, and also the jdbcUrl.
      E.g. for PostgreSQL, the "openidm" at the end is the database name:
      "jdbcUrl" : "jdbc:postgresql://&{openidm.repo.host}:&{openidm.repo.port}/openidm"
       

        Attachments

          Activity

            People

            Assignee:
            Lana Lana Frost
            Reporter:
            wei-yee.lum Wei-Yee Lum
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: