Introduction
BoneCP is a fast, free, open-source, Java database connection pool (JDBC Pool) library. If you are familiar with C3P0 and DBCP then you already know what this means. For the rest, this is a library that will manage a database connection for you to get faster database access in your application.
Details
<bean id="mainDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">
<property name="driverClass" value="com.mysql.jdbc.Driver">
</property>
<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1/yourdb">
</property>
<property name="username" value="root">
</property>
<property name="password" value="abcdefgh">
</property>
<property name="idleConnectionTestPeriod" value="60">
</property>
<property name="idleMaxAge" value="240">
</property>
<property name="maxConnectionsPerPartition" value="30">
</property>
<property name="minConnectionsPerPartition" value="10">
</property>
<property name="partitionCount" value="3">
</property>
<property name="acquireIncrement" value="5">
</property>
<property name="statementsCacheSize" value="100">
</property>
<property name="releaseHelperThreads" value="3">
</property>
</bean>