Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-76676

Active Objects StringLenght's limitations for Oracle

XMLWordPrintable

      Issue Summary

      This is reproducible on Data Center: (yes) / (no)

      Oracle database active objects maps strings fields to varchar2 type with a maximum of 450 characters size (if you configure it with the MAX_LENGTH option of @StringLenght annotation). If you configure as unlimited the string size, active objects maps this field as CLOB. This has an impact if you want to perform any sql query with a filter including this field, as Oracle does not allow to perform a query with a where clause that includes a CLOB type.

      Oracle allows to have a varchar2 with a maximum of 4000 characters.

      Please, reconfigure active objects to allow the 4000 size characters for Oracle.

      Steps to Reproduce

      1. Described above

      Expected Results

      Active Objects should map varchar2 to 4000 characters

      Actual Results

      Active Objects should map varchar2 to 450 characters

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              Unassigned Unassigned
              71f1dad54ffe Wagner M.
              Votes:
              4 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: