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

review queries using QueryFilter with explicit tables in Oracle referring to CLOB field

    Details

      Description

      CLOB fields in Oracle do not allow you to simply compare them to strings. For example:

      select * from openidm.auditsync where mapping = 'foo'
                                            *
      ERROR at line 1:
      ORA-00932: inconsistent datatypes: expected - got CLOB´┐Ż
      

      However this is the sort of code the queryFilter logic will generate when querying against explicit tables. This will cause the queryFilter code to break. There needs to be logic to account for this difference, because several queryFilter queries in the Admin UI filter based on CLOB columns in explicit tables, and as such will fail when using Oracle.

        Attachments

          Activity

            People

            • Assignee:
              jake.feasel Jake Feasel
              Reporter:
              jake.feasel Jake Feasel
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: