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

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. NXP-3995 VCS: allow more flexibility in backend column types

          • Major - Major loss of function.
          • Resolved
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-5231 Webpage edit form : content field is too small

          • Detail - Cosmetic problem like misspelt words or misaligned text.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-6189 Allow largetext fields for string arrays

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: