spring4.x c3p0连接池基本配置ComboPooledDataSource

朴灿烈づ我的快乐病毒、 2022-04-11 05:30 450阅读 0赞

spring applicationContext.xml

<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="com.mchange.v2.c3p0.ComboPooledDataSource">
    	
    	<property name="driverClass" value="${driverClass}" />
    	
    	<property name="jdbcUrl" value="${jdbcUrl}" />
    	
    	<property name="user" value="${user}" />
    	
    	<property name="password" value="password" />	
    
    	
    	<property name="minPoolSize" value="3" />
    	
    	<property name="maxPoolSize" value="15" />
    	
    	<property name="initialPoolSize" value="3" />
    	<property name="testConnectionOnCheckin" value="false"/>
    	<property name="testConnectionOnCheckout" value="true"/>
    	<property name="preferredTestQuery" value="SELECT 1"/>
    </bean>

jdbc.properties

driverClass=com.mysql.jdbc.Driver
    jdbcUrl=jdbc:mysql://localhost:3306/uplatEui?useUnicode=true&characterEncoding=utf-8
    user=root
    password=password

maven pom.xml

<dependency>
    	<groupId>c3p0</groupId>
    	<artifactId>c3p0</artifactId>
    	<version>0.9.1.2</version>
    </dependency>
    
    <dependency>
    	<groupId>com.mchange</groupId>
    	<artifactId>c3p0</artifactId>
    	<version>0.9.5.2</version>
    </dependency>

spring4.x dbcp，dbcp2连接池基本配置BasicDataSource  
http://happyqing.iteye.com/blog/2304131

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