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 <[email protected]> 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 <[email protected]> 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 : [email protected] >> Phone : +94 777 775 729 >> > > > > -- > Ajith Vitharana. > WSO2 Inc. - http://wso2.org > Email : [email protected] > Mobile : +94772217350 > > -- Nuwan Dias Associate Tech Lead - WSO2, Inc. http://wso2.com email : [email protected] Phone : +94 777 775 729
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
