Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-3993

Avoid 2000 characters limit for some fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.2 GA
    • Fix Version/s: 5.3 RC
    • Component/s: Core VCS
    • Impact type:
      Content model Change, Configuration format change
    • Upgrade notes:
      Hide
      • String fields are now by default mapped to a VARCHAR type. You can ALTER TABLE your old database to turn CLOBs into VARCHARs if needed.
      • To have a string field (ex: my:field) mapped to a CLOB, you must give it type="largetext" in the repository config extension point (org.nuxeo.ecm.core.repository.RepositoryService):
        <component name="...">
        <extension target="org.nuxeo.ecm.core.repository.RepositoryService" point="repository">
        <repository name="default" factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
        <repository>
        <schema>
        <field type="largetext">note</field>
        <field type="largetext">my:field</field>
        ...
        </schema>
        ...
        </repository>
        </repository>
        </extension>
        </component>
      Show
      String fields are now by default mapped to a VARCHAR type. You can ALTER TABLE your old database to turn CLOBs into VARCHARs if needed. To have a string field (ex: my:field) mapped to a CLOB, you must give it type="largetext" in the repository config extension point (org.nuxeo.ecm.core.repository.RepositoryService): <component name="..."> <extension target="org.nuxeo.ecm.core.repository.RepositoryService" point="repository"> <repository name="default" factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory"> <repository> <schema> <field type="largetext">note</field> <field type="largetext">my:field</field> ... </schema> ... </repository> </repository> </extension> </component>

      Description

      In some cases the Oracle server fails to set values for some textual fields because the value uploaded is too large. The DB text columns are set to NCHARVAR2(2000), value apparently exceeded by the fields values. The limit of 2000 is intrinsic to Oracle NVARCHAR2, beyond that a NCLOB must be used.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.