Allow portal deployer to choose whether to use C3PO, DBCP, or Primrose for db connection pooling

Brian Chan added a comment - 24/Aug/09 4:54 PM - Restricted to # Liferay can use C3PO, DBCP, or Primrose for connection pooling. See com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean for the actual implementation. It is important to understand the strengths strengths and weaknesses of each provider so that you can choose the best one that fits your deployment scenario. Provider specific properties can also be passed along directly to the provider. For example, the property "jdbc.default.acquireIncrement" is read by C3PO, the property "jdbc.default.maxActive" is read by DBCP, and the property "jdbc.default.base" is read by Primrose. # #jdbc.default.liferay.pool.provider=c3po #jdbc.default.liferay.pool.provider=dbcp jdbc.default.liferay.pool.provider=primrose # The following properties will be read by C3PO if Liferay is configured to use C3PO in the property "jdbc.default.liferayPoolProvider". See http://www.mchange.com/projects/c3p0/index.html#configuration for a list 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 # The following properties will be read by DBCP if Liferay is configured to use DBCP in the property "jdbc.default.liferayPoolProvider". See http://commons.apache.org/dbcp/configuration.html for a list of additional fields used by DBCP for configuring database connections. # jdbc.default.maxActive=50 jdbc.default.minIdel=10 # The following properties will be read by Primrose if Liferay is configured to use Primrose in the property "jdbc.default.liferayPoolProvider". See http://www.primrose.org.uk/primrose3/primroseConfig.html for a list of additional fields used by Primrose for configuring database connections. # jdbc.default.base=50 jdbc.default.idleTime=1800000 jdbc.default.numberOfConnectionsToInitializeWith=10

Brian Chan added a comment - 24/Aug/09 4:59 PM - Restricted to trunk defaults to Primrose 5.1.x and 5.2.x defaults to C3PO.

Brian Chan added a comment - 28/Aug/09 9:05 AM Defaulting all to C3PO.