2.3. Connection Pooling

Hibernate includes a rudimentary internal connection pooling algorithm for development and testing purposes. Use a third party pool for improved performance and stability.

To set a third party connection pool, replace the hibernate.connection.pool_size property with the appropriate settings for your selected connection pool. Setting a new value automatically disabled Hibernate's internal connection pool.

C3P0 is an open source JDBC connection pool that is distributed with Hibernate. C3P0 is available in the lib/ directory. Hibernate uses org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider for connection pooling if the hibernate.c3p0 connection properties are set.

The following table contains hibernate.c3p0 connection properties to set to use the c3p0 connection pool in Hibernate:

To use Hibernate inside an application server, configure Hibernate to obtain connections from an application server (javax.sql.Datasource) that is registered in JNDI. Set more than one of the following properties to configure JNDI to obtain a connection:

Pass custom connection properties by appending the name of the new property to hibernate.connection. For example, to specify a charSet property, specify a new charSet connection property names hibernate.connection.charSet.

Pass custom plugin strategies to obtain JDBC connections by implementing the org.hibernate.service.jdbc.connections.spi.ConnectionProvider and by specifying a custom implementation with the hibernate.connection.provider_class property.