Commonly used connection pool configurations in Spring

First, we prepare the file

jdbc.properties, which is used to save the information about connecting to the database, which is convenient for us to use in the configuration file

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/mybook
jdbc.username=root
jdbc.password=1234

1: The built-in connection pool of the Spring framework (the built-in jar package can be used)

Of course, It uses the configuration of spring-jdbc-4.2.0.RELEASE.jar

in applicationContext.xml (Spring’s configuration file):

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="${jdbc.driver}"></property>
    <property name="url" value="${jdbc.url}"></property>
    <property name="username" value="${jdbc.username}"></property>
    <property name="password" value="${jdbc.password}"></property>
  </bean>

Second: Use c3p0 connection pool

Of course you have to introduce its jar package !

Here I am using: com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar

Configuration in applicationContext.xml (Spring configuration file):

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

Three: Apache’s DBCP connection pool

Of course you need to introduce its jar package!

Here I am using:

com.springsource.org.apache.commons.dbcp-1.2.2.osgi.jar

com.springsource.org.apache.commons.pool-1.3.0.jar

Configuration in applicationContext.xml (Spring configuration file):

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>