DBCP真有BUG吗？

网上很多说,DBCP有BUG.其实这都是使用不深入的缘故.经本人研究，BUG是因为没有设置TEST属性造成.导致CONNECTION无法严整有效性.在每个数据源后面， 本人加上了相关Test代码. 
    本人亲测mysql5.1和sql server 2005,如有问题,请留言,我一定会第一时间帮大家解决^-^ 

Xml代码  

1. <?xml version="1.0" encoding="UTF-8"?>  
2. <beans xmlns="http://www.springframework.org/schema/beans"  
3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
4.     xsi:schemaLocation="http://www.springframework.org/schema/beans  
5.            http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">  
6.              
7.              
8.     <bean id="dataSource_mysql" class="org.apache.commons.dbcp.BasicDataSource">  
9.         <property name="driverClassName">  
10.             <value>com.mysql.jdbc.Driver</value>  
11.         </property>  
12.         <property name="url">  
13.             <value>jdbc:mysql://192.168.0.34:3306/cold</value>  
14.         </property>  
15.         <property name="username">  
16.             <value>root</value>  
17.         </property>  
18.         <property name="password">  
19.             <value>123456</value>  
20.         </property>  
21.         <!-- 以下为可选参数 -->  
22.         <property name="initialSize">  
23.             <value>10</value>  
24.         </property>  
25.         <property name="minIdle">  
26.             <value>10</value>  
27.         </property>  
28.         <property name="maxActive">  
29.             <value>100</value>  
30.         </property>  
31.         <property name="maxIdle">  
32.             <value>100</value>  
33.         </property>  
34.         <property name="validationQuery">  
35.             <value>select count(*) from dual</value>  
36.         </property>  
37.         <property name="testOnBorrow">  
38.             <value>true</value>  
39.         </property>  
40.         <property name="testOnReturn">  
41.             <value>true</value>  
42.         </property>  
43.         <property name="testWhileIdle">  
44.             <value>true</value>  
45.         </property>  
46.         <!--大于0 ，进行连接空闲时间判断，或为0，对空闲的连接不进行验证 -->  
47.         <property name="minEvictableIdleTimeMillis">  
48.             <value>60000</value>  
49.         </property>  
50.         <!--失效检查线程运行时间间隔，如果小于等于0，不会启动检查线程 -->  
51.         <property name="timeBetweenEvictionRunsMillis">  
52.             <value>300000</value>  
53.         </property>  
54.     </bean>  
55.       
56.       
57.     <bean id="dataSource_sqlserver" class="org.apache.commons.dbcp.BasicDataSource">  
58.         <property name="driverClassName">  
59.             <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>  
60.         </property>  
61.         <property name="url">  
62.             <value>jdbc:sqlserver://192.168.0.30:1135;DatabaseName=IceData</value>  
63.         </property>  
64.         <property name="username">  
65.             <value>sa</value>  
66.         </property>  
67.         <property name="password">  
68.             <value>123456</value>  
69.         </property>  
70.         <!-- 以下为可选参数 -->  
71.         <property name="initialSize">  
72.             <value>10</value>  
73.         </property>  
74.         <property name="minIdle">  
75.             <value>10</value>  
76.         </property>  
77.         <property name="maxActive">  
78.             <value>100</value>  
79.         </property>  
80.         <property name="maxIdle">  
81.             <value>100</value>  
82.         </property>  
83.         <property name="validationQuery">  
84.             <value>select getdate()</value>  
85.         </property>  
86.         <property name="testOnBorrow">  
87.             <value>true</value>  
88.         </property>  
89.         <property name="testOnReturn">  
90.             <value>true</value>  
91.         </property>  
92.         <property name="testWhileIdle">  
93.             <value>true</value>  
94.         </property>  
95.         <property name="minEvictableIdleTimeMillis">  
96.             <value>60000</value>  
97.         </property>  
98.         <property name="timeBetweenEvictionRunsMillis">  
99.             <value>300000</value>  
100.         </property>  
101.     </bean>     
102. </beans>