Uploaded image for project: 'LDAP'
  1. LDAP
  2. LDAP-109

ORA-00932: inconsistent datatypes: expected - got CLOB on login

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 9.5.7
    • Fix Version/s: 9.5.8
    • Component/s: Authenticator
    • Labels:
      None
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      If a user profile cannot be found by its uid, it is looked up by dn instead.

       

      This does not work with Oracle, as it maps the XWiki "LargeString" property type to the CLOB type, and fields with this type cannot be used in comparison operators in SQL.

      This makes the login fail with the error message above.

       

       

        Attachments

          Activity

            People

            Assignee:
            camil7 Clemens Robbenhaar
            Reporter:
            camil7 Clemens Robbenhaar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response: