How to configure MySQL connection properties with Spring, Hibernate 3.3 and c3p0?

Posted by sfussenegger on Stack Overflow See other posts from Stack Overflow or by sfussenegger
Published on 2010-03-26T12:47:59Z Indexed on 2010/03/26 15:43 UTC
Read the original article Hit count: 343

Filed under:
|
|
|
|

I am currently in the process of upgrading an application from Hibernate 3.2 to Hibernate 3.3. I though I'd stick with the default connection pool (Hibernate changed its default from Commons DBCP to c3p0) as I don't have any good reason to choose a non-default pool. At least non but having used DBCP before.

The upgrade went pretty much without any problems so far. The only thing I can't get to work is passing properties to the underlying MySQL JDBC4Connection. Up to now, I used DBCP's BasicDataSource.addConnectionProperty(String,String) to pass properties (useUnicode=true, characterEncodin=UTF-8, characterSetResults=UTF-8, zeroDateTimeBehavior=convertToNull).

However, I can't find any way to do the same with c3p0 other than including them in the JDBC URL. (That's something I'd like to avoid as I wanna keep the URL configurable without forcing users to include those parameters.)

So far, I've tried to use a ConnectionCustomizer without success. Any other suggestions?

© Stack Overflow or respective owner

Related posts about java

Related posts about mysql