Optimal BoneCP configuration

376 Views Asked by At

I my web application ,BoneCP DB connection pool configuration as following, it is creating too may DB connection

  1. I need to know what is the default number of DB connection below configuration created
  2. What is the optimal BoneCP configuration( avoiding unwanted connection)
<bean id="appDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">
            <property name="driverClass" value="${database.driverClassName}" />
            <property name="jdbcUrl" value="${database.url}" />
            <property name="username" value="${database.username}"/>
            <property name="password" value="${database.password}"/>
            <!--<property name="idleConnectionTestPeriodInMinutes" value="2"/>-->
            <property name="maxConnectionsPerPartition" value="15"/>
            <property name="minConnectionsPerPartition" value="1"/>
            <property name="partitionCount" value="4"/>
            <property name="acquireIncrement" value="2"/>
            <property name="statementsCacheSize" value="100"/>
            <property name="releaseHelperThreads" value="5"/>
        </bean>
0

There are 0 best solutions below