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.