The Assets are stored in the registry. The fields in db have limited size.
the description column and text areas or any field created is mapped into
the registry table. Using the text-ae in the UI will allow unlimited input
but the column the data is being stored can only handle 1000 characters.
Below is the error message printed.
Asset of type: process was not created due to JavaException:
org.wso2.carbon.governance.api.exception.GovernanceException: Failed to add
artifact: artifact id: 35078821-d4eb-4aa2-a46c-eb2a90a7db68, path:
/process/afdsa/sads/svcd. Failed to add properties to the resource
/_system/governance/process/afdsa/sads/svcd. Value too long for column
"REG_VALUE VARCHAR(1000)": "STRINGDECODE('A system that takes a sequence (a
\""batch\"") of commands or jobs, executes them and returns the results,
all witho... (2746)"; SQL statement:
INSERT INTO REG_PROPERTY (REG_NAME, REG_VALUE, REG_TENANT_ID) VALUES (?, ?,
?) [90005-140]
Regards
Shiva Balachandran
On Fri, Sep 19, 2014 at 1:37 PM, Roshan Wijesena <ros...@wso2.com> wrote:
> Hi Shiva,
>
> I'm just wondering, what prevents you from using a text-area? [1] , it can
> hold unlimited characters.
>
> [1] http://www.w3schools.com/tags/tag_textarea.asp
>
> On Fri, Sep 19, 2014 at 1:11 PM, Shiva Balachandran <sh...@wso2.com>
> wrote:
>
>> Hi,
>>
>> Working with the ES, in order to build an extension, I came across a
>> requirement, a necessity, to hold data in a field which consisted more than
>> 1000 characters. Currently the Enterprise Store only caters to Assets
>> Attributes such as description, provider name, version and others but not
>> for Asset contents or editiable contents field.
>>
>> The description field can only hold up to 1000 characters. The
>> requirement was to provide the user with a content field to input large
>> amounts of textual data such as Business Process Definitions which could
>> exceed 1000 characters.
>>
>> Providing a upload document field to hold extensive data could be viable
>> but will reduce the usability of the store. As the users will have to edit
>> the file and re-upload.
>>
>> What would be a possible workaround?
>> --
>> Shiva Balachandran
>> Software Engineer
>> WSO2 Inc.
>>
>> Mobile - +94 774445788
>>
>> _______________________________________________
>> Architecture mailing list
>> Architecture@wso2.org
>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
>>
>>
>
>
> --
> Roshan Wijesena.
> Senior Software Engineer-WSO2 Inc.
> Mobile: *+94752126789*
> Email: ros...@wso2.com
> *WSO2, Inc. :** wso2.com <http://wso2.com/>*
> lean.enterprise.middleware.
>
--
Shiva Balachandran
Software Engineer
WSO2 Inc.
Mobile - +94 774445788
_______________________________________________
Architecture mailing list
Architecture@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
