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: r...@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) 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 - 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 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 -- -- just because you're paranoid, don't mean they're not after you... gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2 gpgp-key available @ http://pgpkeys.pca.dfn.de:11371 @ http://pgp.mit.edu:11371/ skype:rc46fi _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
