[
https://issues.apache.org/jira/browse/JCR-760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stefan Guggisberg resolved JCR-760.
-----------------------------------
Resolution: Fixed
Fix Version/s: 1.2.3
fixed as suggested in svn r510537
thanks!
> Default blob size for mysql ddl too small
> -----------------------------------------
>
> Key: JCR-760
> URL: https://issues.apache.org/jira/browse/JCR-760
> Project: Jackrabbit
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.2.2
> Reporter: fabrizio giustina
> Priority: Minor
> Fix For: 1.2.3
>
> Attachments: mysql_ddl.diff
>
>
> the default datatype for:
> NODE.NODE_DATA
> PROP.PROP_DATA
> REFS.REFS_DATA
> in the mysql ddl is "BLOB" which is pretty small to the default size in other
> dbs.
> When playing with a (not very large) jackrabbit repo using mysql for
> persistence I easily got data truncation errors on both NODE.NODE_DATA and
> PROP.PROP_DATA columns. The same issue has been reported in the past by other
> users.
> Although anyone could easily create a custom ddl with larger fields it should
> be nice to increase the blob size in the mysql ddl embedded in jackrabbit, in
> order to avoid this kind of problems for new users (you usually learn this
> the hard way, when the number of nodes in your repository starts to grow and
> jackrabbit start throwing errors :/).
> Changing BLOB to MEDIUMBLOB will make the default size for mysql more similar
> to the one in other dbs, without critically increasing the used space...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
