<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"

		init-method="init" destroy-method="close">

		<property name="url"  value="${db.url}" />

        <!-- 数据库用户名称 -->

        <property name="username" value="${db.username}" />

        <!-- 数据库密码 -->

        <property name="password" value="${db.password}" />

        <property name="filters" value="stat"/>

        <property name="maxActive" value="10"/>

        <property name="initialSize" value="1"/>

        <property name="maxWait" value="60000"/>

        <property name="minIdle" value="1"/>

        <property name="timeBetweenEvictionRunsMillis" value="55000"/>

        <property name="minEvictableIdleTimeMillis" value="50000"/>

        <property name="validationQuery" value="SELECT 'x'"/>

        <property name="testWhileIdle" value="true"/>

        <property name="testOnBorrow" value="false"/>

        <property name="testOnReturn" value="false"/>

        <property name="poolPreparedStatements" value="false"/>

        <property name="maxPoolPreparedStatementPerConnectionSize" value="50"/>

        <property name="maxOpenPreparedStatements" value="100"/>

        <property name="removeAbandoned" value="true" /> <!-- 打开removeAbandoned功能 -->

        <property name="removeAbandonedTimeout" value="60" /> <!-- 60秒，也就是1分钟 -->

	</bean>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"

		destroy-method="close">

		<property name="driverClass" value="${db.driverClassName}" />

		<property name="jdbcUrl" value="${db.url}" />

		<property name="user" value="${db.username}" />

		<property name="password" value="${db.password}" />

		<!--连接池中保留的最小连接数。 -->

		<property name="minPoolSize" value="2" />

		<!--连接池中保留的最大连接数。Default: 15 -->

		<property name="maxPoolSize" value="10" />

		<!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->

		<property name="maxIdleTime" value="60" />

		<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->

		<property name="acquireIncrement" value="1" />

		<property name="maxStatements" value="100" />

		<property name="initialPoolSize" value="3" />

		<!--每60秒检查所有连接池中的空闲连接。Default: 0 -->

		<property name="idleConnectionTestPeriod" value="0" />

		<!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->

		<property name="acquireRetryAttempts" value="20" />

		<property name="breakAfterAcquireFailure" value="true" />

		<property name="testConnectionOnCheckout" value="false" />

	</bean>