On 05/29/2011 04:18 AM, Neil Streeter wrote:
On 05/27/2011 03:38 PM, Caleb James DeLisle wrote:
Good report, thanks.
We define sql_mode to work around a hibernate bug: http://jira.xwiki.org/jira/browse/XWIKI-1945 http://opensource.atlassian.com/projects/hibernate/browse/HHH-468
It appears that our workaround has exposed us to a new mysql connector bug: http://bugs.mysql.com/bug.php?id=61201
From the connector bug report it says that 5.1.14 and 5.1.15 are unaffected so you could downgrade your connector version.
Caleb
Hi Caleb,
I started to suspect the params in the hibernate config - and on Friday afternoon I changed the jdbc URL to read simply:
<property name="connection.url">jdbc:mysql://localhost/testxwiki</property>
Everything SEEMS to be working fine at this point - I'm not sure if I'll run in to any problems down the road by not specifying unicode or UTF-8 but it's just in test at the moment. I'll let the list know if I see anything.
The general 'fix' for the 5.1.16 connector seems to be just simplify the connect URL.
I'd be interested in knowing if anyone suspects future issues with what I've done.
I've fixed this for the upcoming 3.2 release, see http://jira.xwiki.org/jira/browse/XE-966 and http://jira.xwiki.org/jira/browse/XE-967 -- Sergiu Dumitriu http://purl.org/net/sergiu/