Hi there, after a long time I am now trying to use XWiki again. I used XWiki 0.9x (two years ago) and I was impressed. Now I tried to upgrade to the new version 1.3 and started with a fresh environment mentioned in the installation guide (http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation).
I use MySQL 5.0 and Tomcat 5.5 (JRE 1.5). After doing all the steps and point to the XWiki starting page, I got several exceptions in the log. All of type which are described in XWIKI-1879 and XWIKI-1945. Setting SQL_MODE to '' has no effect here, but deleting useServerPrepStmts=false do the trick. After deleting this from the connection string and starting again in a fresh environment (drop tables) everything is working perfectly. Although the migration of my old database from XWiki 0.9x is now working. It seems, that the flag 'useServerPrepStmts= false' do the opposite in a MySQL 5.x environment... And I found why:-) I used the MySQL java connector 3.1.2 with MySQL 5.x and this is not properly working with 'useServerPrepStmts= false' (see http://opensource.atlassian.com/projects/hibernate/browse/HBX-729 and http://bugs.sakaiproject.org/jira/browse/SAK-9250) After upgrading to mysql connector 5.0.x the flag 'useServerPrepStmts= false' is working. Bye and good night Frank _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
