spring4.x dbcp，dbcp2连接池基本配置BasicDataSource

不念不忘少年蓝@ 2022-04-11 05:30 267阅读 0赞

**一、dbcp**

spring配置文件

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    	<property name="locations">
    		<list>
    			<value>classpath:jdbc.properties</value>
    		</list>
    	</property>
    </bean>
    
    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    	destroy-method="close">
    	<property name="driverClassName" value="${driverClassName}" />
    	<property name="url" value="${url}" />
    	<property name="username" value="${username}" />
    	<property name="password" value="${password}" />
    	
    	<property name="initialSize" value="3" />
    	
    	<property name="minIdle" value="3" />
    	
    	<property name="maxIdle" value="5" />
    	
    	<property name="maxActive" value="15" />
    	<property name="validationQuery" value="SELECT 1" />
    	<property name="testOnBorrow" value="true"/>
    </bean>

jdbc.properties

#dbcp
    driverClassName=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/uplatEui?useUnicode=true&characterEncoding=utf-8
    username=root
    password=password

maven pom.xml

<dependency>
        <groupId>commons-dbcp</groupId>
        <artifactId>commons-dbcp</artifactId>
        <version>1.4</version>
    </dependency>

**二、dbcp2**

dbcp2需要jdk1.7，否则会报错：Unsupported major.minor version 51.0

maxActive改为了maxTotal

spring配置文件

<bean id="dataSource2" class="org.apache.commons.dbcp2.BasicDataSource"
    	destroy-method="close">
    	<property name="driverClassName" value="${driverClassName}" />
    	<property name="url" value="${url}" />
    	<property name="username" value="${username}" />
    	<property name="password" value="${password}" />
    	
    	<property name="initialSize" value="3" />
    	
    	<property name="minIdle" value="3" />
    	
    	<property name="maxIdle" value="5" />
    	
    	<property name="maxTotal" value="15" />
    </bean>

maven pom.xml

<dependency>
        <groupId>org.apache.commons</groupId>
        <artifactId>commons-dbcp2</artifactId>
        <version>2.1.1</version>
    </dependency>

spring4.x c3p0连接池基本配置ComboPooledDataSource  
http://happyqing.iteye.com/blog/2303239

spring4.x jdbcTemplate配置，事务配置  
http://happyqing.iteye.com/blog/2303240