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