|
Connection pooling in HibernateHibernate has native connection pooling available which it does not recommend for use but still its good enough to appear in many commercial and large sized deployments. One of the problems the native connection pool has is that it does not try to keep-alive the connections which are closed by the DB due to inactivity. So, for example, if there is lesser load during the night and heavy during the morning time, then the connections lost during night have to be re-made and that adds to the already loaded system in the morning. An easier alternative to the native hibernate connection pool is to use C3P0 library that augments the standard JDBC libraries by providing an excellent connection pool. Hibernate just needs some property file bindings to make it switch to C3P0 pool. To use C3P0, following steps are required: 1) Add C3P0 jar 2) Add following to hibernate.cfg.xml 
3) Add a c3p0.properties file |
Got a thought to share or found a
bug in the code?
We'd love to hear from you:
| Name: | |
| Email: | (Your email is not shared with anybody) |
| Comment: |
Facebook comments:
