Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-7080

PostgreSQL DatabaseTableConnector with UUID datatype for keyColumn

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.3
    • Fix Version/s: None
    • Component/s: Connectors
    • Labels:
      None
    • Environment:

      midPoint version: 4.3
      DatabaseTableConnector version: 1.4.6.0
      PostgreSQL version: AWS aurora-postgresql engine version 12.4
      Deployment environment: AWS ECS

    • Subscription:
      Active subscription

      Description

      In connector configuration, for the keyColumn, the datatype in database is UUID. With that configuration, we are getting following error in connector test:

      ERROR (org.identityconnectors.databasetable.DatabaseTableConnector): method: [null, Query SELECT ...name , status FROM hkl.v_person WHERE id = ? on ObjectClass: __ACCOUNT__ error] msg:{}"
      org.postgresql.util.PSQLException: ERROR: operator does not exist: uuid = character varying"
      Hint: No operator matches the given name and argument types. You might need to add explicit type casts."

       

      To avoid this error, we can use a database view and CAST the UUID datataype to varchar. Support of  PostgreSQL UUID datatype in connector will simplify our deployment.

        Attachments

          Activity

            People

            Assignee:
            mahbub_rahman@harvard.edu Mahbub Rahman
            Reporter:
            mahbub_rahman@harvard.edu Mahbub Rahman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: