Changes for page MySQL Installation

Last modified by Thomas Mortagne on 2023/11/16

<
From version < 4.5 >
edited by 2smart4u
on 2010/03/05
To version < 5.1 >
edited by 2smart4u
on 2010/03/05
>
Change comment: MySQLConnectorJ 3.1.14 does not handle UTF-8 properly

Summary

Details

Page properties
Content
... ... @@ -63,3 +63,23 @@
63 63  mysql -u xwiki -p xwiki -h 127.0.0.1 < mycommands.sql
64 64  {code}
65 65  
66 +1.1.1 Data Truncation Error
67 +
68 +If you receive an Exception like the following while installing / upgrading XWiki:
69 +
70 +{code}
71 +Caused by: java.sql.BatchUpdateException: Data truncation: Out of
72 +range value adjusted for column 'XWD_HIDDEN' at row 1
73 + at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:894)
74 + at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
75 + at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
76 + at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
77 + at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
78 +{code}
79 +
80 +chances are, that you are using an outdated version of MySQLConnectorJ.
81 +
82 +On Linux, mysql-connector-java-3.1.14-bin.jar has proven *not* to work due to a bug in the handling of UTF-8.
83 +
84 +Upgrade to the latest version of MySQLConnectorJ should solve such an error in most of the cases.
85 +

Get Connected