PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-4646

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 5.1.2, 5.2.3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Branch Version/s:
      5.2.x, 5.1.x
    • Backported to Branch:
      Committed
    • Similar Issues:
      Show 5 results 

      Activity

      Hide
      Brian Chan added a comment - - Restricted to

      #

      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 strengths and
      4. weaknesses of each provider so that you can choose the best one that fits
      5. your deployment scenario. Provider specific properties can also be passed
      6. along 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.
        #
        #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=50
        jdbc.default.minIdel=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=50
        jdbc.default.idleTime=1800000
        jdbc.default.numberOfConnectionsToInitializeWith=10
      Show
      Brian Chan added a comment - - 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
      Hide
      Brian Chan added a comment - - Restricted to

      trunk defaults to Primrose

      5.1.x and 5.2.x defaults to C3PO.

      Show
      Brian Chan added a comment - - Restricted to trunk defaults to Primrose 5.1.x and 5.2.x defaults to C3PO.
      Hide
      Brian Chan added a comment -

      Defaulting all to C3PO.

      Show
      Brian Chan added a comment - Defaulting all to C3PO.

        People

        • Assignee:
          SE Support
          Reporter:
          Brian Chan
          Recent user:
          Randy Zhu
          Participants of an Issue:
        • Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

          Dates

          • Created:
            Updated:
            Resolved:
            Days since last comment:
            6 years, 2 weeks ago

            Development

              Subcomponents

                Structure Helper Panel