New connection pool options

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP3 (5.1.6), 5.2 EE SP1 (5.2.5)
• Fix Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP2 (5.2.6)
• Component/s: Environments > Databases
• Labels:
  • 5.2_release_notes
• Environment: All

In addition to C3PO, DBCP and Primrose can now be used for connection pooling.

A different connection pool can be used by modifying portal(-ext).properties

#

1. Liferay can use C3PO, DBCP, or Primrose for connection pooling. See
2. com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean for the actual
3. implementation. It is important to understand the strengths and weaknesses
4. of each provider so that you can choose the best one that fits your
5. deployment scenario. Provider specific properties can also be passed along
6. directly to the provider. For example, the property
7. "jdbc.default.acquireIncrement" is read by C3PO, the property
8. "jdbc.default.maxActive" is read by DBCP, and the property
9. "jdbc.default.base" is read by Primrose.
   #
10. The default provider is C3PO.
    #
    jdbc.default.liferay.pool.provider=c3po
    #jdbc.default.liferay.pool.provider=dbcp
    #jdbc.default.liferay.pool.provider=primrose

#

1. The following properties will be read by C3PO if Liferay is configured to
2. use C3PO in the property "jdbc.default.liferayPoolProvider". See
3. http://www.mchange.com/projects/c3p0/index.html#configuration for a list
4. of additional fields used by C3PO for configuring database connections.
   #
   jdbc.default.acquireIncrement=5
   jdbc.default.maxIdleTime=3600
   jdbc.default.maxPoolSize=100
   jdbc.default.minPoolSize=10
   jdbc.default.numHelperThreads=3

#

1. The following properties will be read by DBCP if Liferay is configured to
2. use DBCP in the property "jdbc.default.liferayPoolProvider". See
3. http://commons.apache.org/dbcp/configuration.html for a list of additional
4. fields used by DBCP for configuring database connections.
   #
   jdbc.default.maxActive=100
   jdbc.default.minIdle=10

#

1. The following properties will be read by Primrose if Liferay is configured
2. to use Primrose in the property "jdbc.default.liferayPoolProvider". See
3. http://www.primrose.org.uk/primrose3/primroseConfig.html for a list of
4. additional fields used by Primrose for configuring database connections.
   #
   jdbc.default.base=100
   jdbc.default.idleTime=1800000
   jdbc.default.numberOfConnectionsToInitializeWith=10