It is possible to extend the size of the columns XWS_VALUE in the table xwikistrings in the MySQL database.
I've run in some cases where a bigger field is necessary without wanting to move to a TextArea. I think it could make sense that we make this field bigger in the xwiki hibernate mapping
Ludovic Le 07/12/10 12:10, farouk korteby a écrit :
Hi, The string property is limited to 255 chars, you must use text-area property. Take look at \xwiki-enterprise-jetty-hsqldb-2.0.2\webapps\xwiki\WEB-INF\lib\xwiki-core-xx.jarxwiki.hbm.xml----------------------------------------------------------------------------------------------------- <joined-subclass name="com.xpn.xwiki.objects.StringProperty" table="xwikistrings"> <key> <column name="XWS_ID" /> <column name="XWS_NAME" /> </key> <property name="value" type="string"> <column name="XWS_VALUE" *length="255"* /> </property> </joined-subclass> ----------------------------------------------------------------------------------------------------- 2010/12/7 Marius Dumitru Florea<[email protected]>Hi devs, I have a serious problem. I'm using a fresh XE 2.6 with MySql (fresh db + XE 2.6 XAR import) and I'm doing this: 1. Create a class Main.TestClass with only one property (say "city") of type "String". 2. Add an object of type Main.TestClass to Main.TestClass page and set the value of "city" to a large string (say 270 characters). 3. Save. I get: ----------8<---------- org.hibernate.exception.DataException: could not insert: [com.xpn.xwiki.objects.StringProperty] ... Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'XWS_VALUE' at row 1 ---------->8---------- IMO "Data too long" should be only a warning. Why isn't the string simply truncated if it's too long? If I go back to the object editor the value of the "city" property is empty. If I try to set the value to a short string, say "Paris" and then save, I get: ----------8<---------- Failed to commit or rollback transaction. Root cause [] ... Wrapped Exception: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [com.xpn.xwiki.objects.StringProperty#<?xml version="1.0" encoding="UTF-8"?> <city>Paris</city> ] ---------->8---------- So how can I fix this? If I delete the object and then create a new one, setting the value of "city" to "Rome" I get the same exception as before, but with: <city>Rome</city> Is this related to my configuration? Thanks, Marius _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
<<attachment: ludovic.vcf>>
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
