SearchRequest entity should use a extemely-long field types on Oracle 10g

XMLWordPrintable

      Currently the SearchRequest entity is defined like this :

       <entity entity-name="SearchRequest" table-name="searchrequest" package-name="">
             ...
              <field name="request" col-name="reqcontent" type="very-long"/>
      
          </entity>
      

      On Oracle 10g this is defined as varchar(4000). This means that search requests cant be bigger than that.

      It could be this :

       <entity entity-name="SearchRequest" table-name="searchrequest" package-name="">
             ...
              <field name="request" col-name="reqcontent" type="extremely-long"/>
      
          </entity>
      

      We had a customer who migrated from MYSQL (very-long ~ 32K) to ORACLE 10G and had problems because they had search requests > 4K

      We should up the limit for Oracle 10g in the next release of JIRA.

      We may want to consider other enities that use 'very-long' when we do this.

              Assignee:
              Unassigned
              Reporter:
              ɹǝʞɐq pɐɹq
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: