Hi Uvindra,
On Fri, May 9, 2014 at 5:47 PM, Uvindra Dias Jayasinha <uvin...@wso2.com>wrote:
> This limitation was highlighted during the discussion we had with Ajith
> just before work on the API Store forum was started. As I mentioned we ran
> into the same limitation when developing the development governance
> solution. The text area that was to store custom javascript rules could not
> accommodate anything exceeding 1000 characters. In the end after discussing
> with Senaka we solved the problem by increasing the column size of
> REG_VALUE to 5000 and changing the DB scripts that were shipped with the
> solution accordingly.
>
So, what happen when the length is 5001 ? :)
Thanks.
Ajith.
>
>
> On Fri, May 9, 2014 at 5:29 PM, Nuwan Dias <nuw...@wso2.com> wrote:
>
>> Hi Ajith,
>>
>> We're developing a forum for the API Store using the registry as the
>> storage medium. Each topic/reply is stored in the registry as an artifact.
>> Topics/Replies have a rich text editor which supports code blocks, etc.
>> This text-area has been mapped to a text-area field in the rxt. So limiting
>> the characters to < 1000 is not very feasible in this scenario.
>>
>> Are you saying that increasing the column size of REG_VALUE is not a good
>> idea?
>>
>> Thanks,
>> NuwanD.
>>
>>
>> On Fri, May 9, 2014 at 5:22 PM, Ajith Vitharana <aji...@wso2.com> wrote:
>>
>>> Hi Nuwan,
>>>
>>> We store the each filed as properties of the artifacts, that is the data
>>> model used. Anyway, having the 1000 characters for the given field is a
>>> special case.
>>> So, it is not better to increase the default schema to handle this use
>>> case.
>>>
>>> Can't we limit the characters length for that text-area ?
>>>
>>> Thanks.
>>> Ajith.
>>>
>>>
>>> On Fri, May 9, 2014 at 3:18 PM, Nuwan Dias <nuw...@wso2.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I have an rxt on which I am using a text-area field. However I get the
>>>> following error if I am to put more that 1000 characters in the field.
>>>>
>>>> org.h2.jdbc.JdbcSQLException: Value too long for column "REG_VALUE
>>>> VARCHAR(1000)": "STRINGDECODE('<table><tbody><tr><td
>>>> class=\""votecell\""><div class=\""vote\"">\n <span
>>>> class=\""vote-count-post \"">2</span>\n ... (1107)"; SQL statement:
>>>> INSERT INTO REG_PROPERTY (REG_NAME, REG_VALUE, REG_TENANT_ID) VALUES
>>>> (?, ?, ?) [90005-140]
>>>>
>>>> The reason for the above problem is due to the fact that each field in
>>>> the rxt is also saved as a rxt property. The column length in the database
>>>> for the property value is 1000 characters. Therefore basically its not
>>>> possible to have a field in the rxt which is more than 1000 characters
>>>> long.
>>>>
>>>> I see this as a serious limitation. The only possible workaround I see
>>>> is to increase the column size. Any other solutions to this? Why do we need
>>>> to have a property corresponding to each field in the rxt? If we can get
>>>> rid of that, then we're good IMO.
>>>>
>>>> Thanks,
>>>> NuwanD.
>>>>
>>>> --
>>>> Nuwan Dias
>>>>
>>>> Associate Tech Lead - WSO2, Inc. http://wso2.com
>>>> email : nuw...@wso2.com
>>>> Phone : +94 777 775 729
>>>>
>>>
>>>
>>>
>>> --
>>> Ajith Vitharana.
>>> WSO2 Inc. - http://wso2.org
>>> Email : aji...@wso2.com
>>> Mobile : +94772217350
>>>
>>>
>>
>>
>> --
>> Nuwan Dias
>>
>> Associate Tech Lead - WSO2, Inc. http://wso2.com
>> email : nuw...@wso2.com
>> Phone : +94 777 775 729
>>
>> _______________________________________________
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
> Regards,
> Uvindra
>
> Mobile: 777733962
>
--
Ajith Vitharana.
WSO2 Inc. - http://wso2.org
Email : aji...@wso2.com
Mobile : +94772217350
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
