12 May
2009
12 May
'09
11:32 p.m.
Niels Mayer wrote:
In 1.8, if too much data is entered in a doc's
?editor=object
fieldXWiki.JavaScriptExtension[] (say
a big chunk of JSON on the order of 97783 bytes) you can no longer save
without getting an underlying error. This appears related to the following:
com.xpn.xwiki.objects.LargeStringProperty -->
com.mysql.jdbc.MysqlDataTruncation:
Data truncation: Data too long for column 'XWL_VALUE' at row 1
How can this be changed to allow for a larger limit on entries? Fortunately,
http://nielsmayer.com/xwiki/bin/view/Exhibit/Presidents3 ( src
<http://nielsmayer.com/xwiki/bin/download/Exhibit/Presidents3/Exhibit.Presidents3.xar>)
has entries small enough, but as you grow the amount of Javascript data you
hold in a XWiki.JavaScriptExtension you eventually get a failure like this:
This is a LargeStringProperty, which by defaults is configured to hold
at least 60000 chars. In mysql, this translates to a TEXT column, which
can hold 65,535 characters.
Locally, you can alter the xwikilargestrings table to convert the
XWL_VALUE column to MEDIUMTEXT to get past this issue.
Globally, we can consider increasing the size for this field, but I
don't know if it's a good idea. You should keep your files small. On the
other hand, this also affects other objects, so for example long blog
articles won't fit.
Another idea is to put the file as an attachment on the skin document,
or in the filesystem, and call it with the jsfx plugin instead of the
jsx one. The drawback is that it will be a bit harder to edit, as you
will need to change it locally and then re-attach it.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/