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

Migrate largetext field to clob field using XSD definition

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8
    • Fix Version/s: 5.9.1
    • Component/s: Core
    • Impact type:
      Configuration Change
    • Upgrade notes:
      • largetext definition removed from default-repository-config.xml
      • now used nx:string whose size is 999999999 (=CLOB at database level) for large text fields

      Description

      The default VCS configuration defines some fields as large text

              <schema>
                <field type="largetext">note</field>
                <field type="largetext">relatedtext</field>
                <field type="largetext">webp:content</field>
                <field type="largetext">webc:welcomeText</field>
                <field type="largetext">comment:text</field>
                <field type="largetext">post</field>
                <field type="largetext">mail:mail</field>
              </schema>
      

      whereas this configuration should be part of the definition of the corresponding schemas with this kind of code:

        <xs:simpleType name="clob">
          <xs:restriction base="xs:string">
            <xs:maxLength value="999999999" />
          </xs:restriction>
        </xs:simpleType>
        <xs:element name="note" type="nxs:clob"/>
      

      We need to update these fields and let users configure large text for fields that need larger column for their own cases

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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