Add Spring setup to documentation (ideas included)

[brmeyer]

Hey @brettwooldridge, finally getting around to playing with HikariCP/Hibernate on a non-profit I support (nlfw.org). Working beautifully so far. Very, very glad to delete C3P0 from the dependencies ;)

For what it's worth, this is my Spring configuration. It might be beneficial to throw something like this in your docs.

https://gist.github.com/brmeyer/bbb8688658dd71752738

Note that I'm using the annotation-based Spring configuration, but the concepts would be similar through XML.

Just thought I'd throw that out there!

[brettwooldridge]

Hey thanks for that! Is this limited to particular versions of Spring and/or Hibernate?

[brmeyer]

I'm currently using ORM 4.2.12.Final and Spring 3.2.8.RELEASE, but it shouldn't matter too much. Since you're directly feeding the HikariDataSource to the LocalSessionFactoryBean#setDataSource, specific versions are less important. It sidesteps the HikariCP <-> Hibernate integration (at least w/ respect to the ConnectionProvider, etc.) entirely.

[brmeyer]

Quick blog post with more info: http://www.3riverdev.com/blog/tutorial-spring-hibernate-hikaricp/

[brmeyer]

Also for what it's worth (somewhat different topic), I branched HikariCP for use with ORM 4.2.x, since our ConnectionProvider SPI is slightly different there. Not sure if you'd want to do anything with it, but what the heck:

https://github.com/brmeyer/HikariCP/tree/HibernateORM4.2

There will continue to be many users who won't upgrade to 4.3 for a while, largely due to Spring not supporting it until version 4 (in addition to other frameworks).

[brettwooldridge]

Added documentation to the wiki.