Mapping between XML service definition and database storage

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Won't Fix
    • None
    • Environment:
      SLES 2.6.16.60-0.67.1-xen #1 SMP x86_64 x86_64
      java version "1.6.0_17"
      Java(TM) SE Runtime Environment (build 1.6.0_17-b04)
      Java HotSpot(TM) 64-Bit Server VM (build 14.3-b01, mixed mode)
      Jira Standalone

      When I define services in XML file (which defined UI) which used by com.atlassian.jira.service.AbstractService#getObjectConfiguration()

      There is some field type. But the mapping with String and text is strange.
      When I define string, It's represented by an unlimited text input.
      A UI controle limits to 255 chars the flied value, otherwise

      Errors

      • Error occurred trying to update service properties: com.opensymphony.module.propertyset.IllegalPropertyException: String exceeds 255 characters

      It stored in PROPERTYSTRING limited to 4000 chars,

      When I define text, It's represented by an unlimited text area.
      But it also stored in PROPERTYSTRING, where I expect it to be stored in PROPERTYTEXT

      So actually :

      XML type UI control Database table Database limit
      string 255 PROPERTYSTRING 4000
      text 255 PROPERTYSTRING 4000

      It would be more consistent to do

      XML type UI control Database table Database limit
      string 4000 PROPERTYSTRING 4000
      text none PROPERTYTEXT none
      service.xml
      <?xml version="1.0" encoding="UTF-8"?>
      <userservice id="service_id">
      <description>description</description>
      <properties>
      ...
      <property>
      	<key>Key</key>
      	<name>name</name>
      	<description>description</description>
      	<type>string</type>
      </property>
      <property>
      	<key>another key</key>
      	<name>another name</name>
      	<description>another description</description>
      	<type>string</type>
      </property>
      ...
      </properties>
      </userservice>
      

            Assignee:
            Unassigned
            Reporter:
            Fabrice Porcher
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: