Sping管理数据源
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
<bean id="mySqlDataSource" name="mySqlDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<!-- 驱动 -->
<property name="driverClass" value="${c3p0.driverClass}" />
<!-- 连接地址 -->
<property name="jdbcUrl" value="${c3p0.url}" />
<!-- 用户名 -->
<property name="user" value="${c3p0.username}" />
<!-- 密码 -->
<property name="password" value="${c3p0.password}" />
<!--连接池中保留的最小连接数。 -->
<property name="minPoolSize" value="${c3p0.minPoolSize}" />
<!--连接池中保留的最大连接数。Default: 15 -->
<property name="maxPoolSize" value="${c3p0.maxPoolSize}" />
<!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
<property name="maxIdleTime" value="${c3p0.maxIdleTime}" />
<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
<property name="acquireIncrement" value="${c3p0.acquireIncrement}" />
<property name="maxStatements" value="${c3p0.maxStatements}" />
<property name="initialPoolSize" value="${c3p0.initialSize}" />
<!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
<property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}" />
<!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
<property name="acquireRetryAttempts" value="${c3p0.acquireRetryAttempts}" />
<property name="breakAfterAcquireFailure" value="${c3p0.breakAfterAcquireFailure}" />
<property name="testConnectionOnCheckout" value="${c3p0.testConnectionOnCheckout}" />
</bean>
<context:property-placeholder location="classpath:c3p0/mysql.properties" />
</beans>
mysql.properties
c3p0.driverClass=com.mysql.jdbc.Driver
c3p0.url=jdbc:mysql://192.168.0.226:3306/jabberd2?useUnicode=true&characterEncoding=utf-8
c3p0.username=root
c3p0.password=123456
c3p0.minPoolSize=10
c3p0.maxPoolSize=15
c3p0.maxIdleTime=1800
c3p0.acquireIncrement=3
c3p0.maxStatements=100
c3p0.initialSize=10
c3p0.idleConnectionTestPeriod=0
c3p0.acquireRetryAttempts=30
c3p0.breakAfterAcquireFailure=true
c3p0.testConnectionOnCheckout=false
下载c3p0