<!-- -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="jdbcUrl">
<value>jdbc:mysql://localhost:3306/dog</value>
</property>
<!-- 3 -->
<!-- -->
<property name="idleConnectionTestPeriod">
<value>18000</value>
</property>
<!-- 3 -->
<property name="maxIdleTime">
<value>25000</value>
</property>
<!-- -->
<property name="testConnectionOnCheckin">
<value>true</value>
</property>
<property name="testConnectionOnCheckout">
<value>true</value>
</property>
<!-- -->
<property name="preferredTestQuery">
<value>select 1</value>
</property>
<property name="properties">
<props>
<prop key="user">root</prop>
<prop key="password">123456</prop>
<prop key="c3p0.acquire_increment">5</prop>
<prop key="c3p0.idle_test_period">18000</prop>
<!-- -->
<prop key="c3p0.timeout">20000</prop>
<prop key="c3p0.max_size">40</prop>
<prop key="c3p0.max_statements">100</prop>
<prop key="c3p0.min_size">10</prop>
</props>
</property>
</bean>