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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
