Hi, On Thu, Apr 9, 2009 at 1:52 AM, Sergiu Dumitriu <[email protected]> wrote:
Hi devs,
While trying to fix XWIKI-1480, the following question was raised: What to do with large values placed inside a StringProperty?
StringProperties are defined to hold at most 255 characters (which are actually bytes in mysql). Some databases automatically ignore this limit (this is the case with hsql, which is the default database for our standalone package), while others throw exceptions when trying to commit the transaction (mysql does this).
Currently, we don't handle this exception at all, so it bubbles up to the UI in the form of a stack trace. XWIKI-1480 is about fixing this error.
What can be done:
1. Always trim the content to 255 bytes. This is a regression from the point of view of hsql users, which will suddenly notice that their data gets truncated.
2. If the data is larger than 255 bytes, silently ignore this new value, and continue using the previous one. This is also bad, since users won't understand why doesn't the value get saved, and is a regression on hsql.
3. Try to use this value, but if an exception is thrown, truncate the data and commit again. This fixes the regression part, but might still be surprising to users.
4. Continue as before, but catch the exception and display a nice warning message to the user. This looks like the safest approach, but it fails when manipulating data from outside the UI, like scripts and XmlRpc connections.
So, what is the best approach?
What about a mix of 3) & 4) ? Try using the value, but if an exception is thrown truncate the data and commit again. Then display a warning message to the user saying that his content has been truncated because it was too long and that only 255 chars are allowed for the property that threw the exception. The message wouldn't be displayed when manipulating data from script, but I don't think that's much of the problem -> it becomes the script's author problem at that point. WDYT? Guillaume
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Guillaume Lerouge Product Manager - XWiki Skype ID : wikibc http://guillaumelerouge.com/