C3P0数据源配置

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
	<named-config name="oracle">
		<property name="user">scott</property>
		<property name="password">admin</property>
		<property name="jdbcUrl">jdbc:oracle:thin:@127.0.0.1:1521:lgf</property>
		<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
		<property name="acquireIncrement">10</property>
		<property name="initialPoolSize">20</property>
		<property name="minPoolSize">10</property>
		<property name="maxPoolSize">3000</property>
		<property name="maxStatements">30</property>
		<property name="maxStatementsPreConnection">5</property>
		<property name="acquireRetryAttempts">0</property>
		<property name="acquireRetryDelay" >1000</property>
		<property name="idleConnectionTestPeriod">60</property>
		<property name="checkoutTimeout">120000</property>
		<property name="propertyCycle">300</property>
		<property name="testConnectionOnCheckin">true</property> 
	</named-config>
	<named-config name="sqlserver">
		<property name="user">sa</property>
		<property name="password">accp</property>
		<property name="jdbcUrl">jdbc:sqlserver://localhost:1433;DatabaseName=easybuy</property>
		<property name="driverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
		<property name="acquireIncrement">10</property>
		<property name="initialPoolSize">20</property>
		<property name="minPoolSize">10</property>
		<property name="maxPoolSize">3000</property>
		<property name="maxStatements">30</property>
		<property name="maxStatementsPreConnection">5</property>
		<property name="acquireRetryAttempts">0</property>
		<property name="acquireRetryDelay" >1000</property>
		<property name="idleConnectionTestPeriod">60</property>
		<property name="checkoutTimeout">120000</property>
		<property name="propertyCycle">300</property>
		<property name="testConnectionOnCheckin">true</property> 
	</named-config>
	<named-config name="mysql">
		<property name="user">root</property>
		<property name="password"></property>
		<property name="jdbcUrl"><![CDATA[jdbc:mysql://localhost:3306/test]]></property>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="acquireIncrement">10</property>
		<property name="initialPoolSize">20</property>
		<property name="minPoolSize">10</property>
		<property name="maxPoolSize">3000</property>
		<property name="maxStatements">30</property>
		<property name="maxStatementsPreConnection">5</property>
		<property name="acquireRetryAttempts">0</property>
		<property name="acquireRetryDelay" >1000</property>
		<property name="idleConnectionTestPeriod">60</property>
		<property name="checkoutTimeout">120000</property>
		<property name="propertyCycle">300</property>
		<property name="testConnectionOnCheckin">true</property> 
	</named-config>
</c3p0-config>
<!-- 1.配置参数名称 -->
<!-- user 用户名 -->
<!-- password 密码 -->
<!-- jdbcUrl 数据库连接路径 -->
<!-- driveClass 驱动类 -->
<!-- acquireIncrment 每次创建多少个连接 -->
<!-- intitilPoolSize 初始化连接 -->
<!-- minPlloSize 最小连接 -->
<!-- maxPlloSize 最大连接 -->
<!-- maxStatements 最大的statement对象 -->
<!-- maxStatementsPreConnection 每个连接最多创建多少个statement对象 -->
<!-- acquireRetryAttempts 定义在从数据库获取新连接失败后重复尝试的次数。默认值: 30 次；小于等于0表示无限次 -->
<!-- acquireRetryDelay 重新尝试的时间间隔，默认为：1000毫秒 -->
<!-- idleConnectionTestPeriod 每60秒检查所有连接池中的空闲连接。默认值: 0，不检查 --> 
<!-- checkoutTimeout 当连接池用完时客户端调用getConnection()后等待获取新连接的时间，超时后将抛出 单位毫秒 默认0(无限) -->
<!-- propertyCycle 用户修改系统配置参数执行前最多等待300秒。Default: 300 --> 
<!-- testConnectionOnCheckin 如果设为true那么在取得连接的同时将校验连接的有效性。Default: false -->