5 Mar
2010
5 Mar
'10
2:14 p.m.
On 03/05/2010 12:17 PM, 2smart4u wrote:
Hi guys,
first off, thanks to VBincent, Anca& Sdumitriu for pointing me to
this list via Twitter
My current environment:
Using CATALINA_BASE: /home/tomcat/www
Using CATALINA_HOME: /home/tomcat/www
Using CATALINA_TMPDIR: /home/tomcat/www/temp
Using JRE_HOME: /usr/lib/jvm/java-1.6.0-sun
Server version: Apache Tomcat/5.5.20
Server built: Sep 12 2006 10:09:20
Server number: 5.5.20.0
OS Name: Linux
OS Version: 2.6.18-4-686
Architecture: i386
JVM Version: 1.6.0_10-b33
JVM Vendor: Sun Microsystems Inc.
I'm running on Debia, but I'm not using a packaged version but a
vanilla Tomcat installation
MySQL:
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
Connection id: 57
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.32-Debian_7etch11-log Debian etch distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 14 days 21 hours 38 min 38 sec
Now I know what you guys are saying - "you have to set up a
UTF-8-databse", but well, should be enough if the database is set to
use UTF-8 and not the whole MySQL-instance,right?
Therefore:
mysql> show create database xwiki;
+----------+----------------------------------------------------------------+
| Database | Create Database |
+----------+----------------------------------------------------------------+
| xwiki | CREATE DATABASE `xwiki` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)
In mysql each table and each column can have its own charset. Make sure
that it's not just the global database that was created using utf8, but
also the columns. A quick test:
select distinct charset(xwd_content) from xwikidoc;
Now what I did so far:
- I downloaded the latest stand-alone war from the xwiki-website
- I created a new Virtual Host within Tomcat and deployed the war
- I commented out the default HSQL-DB-settings and adapted the
MySQL-settings in hibernate.cfg.xml:
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property>
<property name="connection.username">someUser</property>
<property name="connection.password">somePassword</property>
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property
name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">2</property>
<property name="statement_cache.size">2</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
- in xwiki.cfg, I left everything at their default values except
xwiki.store.migration=0
Did you also download the mysql connector as indicated on
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL ?
http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.12/mysql-conne…
- I restartet Tomcat, and then went to
http://myServer/xwiki/bin/import/XWiki/XWikiPreferences
to import the default pages as suggested in the docs.
However, I'm getting a HTTP 500 with the following exception:
Caused by: java.sql.BatchUpdateException: Data truncation: Out of
range value adjusted for column 'XWD_HIDDEN' at row 1
This usually happens when version 3.x of the mysql connector is used.
Installing the 5.x version should solve it, but this is not a very
serious error (it would just mean that all documents will be hidden).
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:894)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
/There are a lot more exeption, but the above one should be the root-cause.
My understanding is, that some mapping within Hibernate is wrong, but
I got no idea on how to fix that.
Any suggestions would be very much appreciated.
TIA
Gregor
PS.: I'm running Tomcat as a demon via jsvc, but I don't think that
this has anything to do with the above error
--
Sergiu Dumitriu
http://purl.org/net/sergiu/