SSH2+proxool 出现No suitable driver found for proxool.mysqlP

	<bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">  
		<property name="alias" value="mysqlProxool"/>
		<property name="driver" value="com.mysql.jdbc.Driver"/>
		<property name="driverUrl" value="jdbc:mysql://localhost:3306/my_blog_01?characterEncoding=UTF-8"/>
		<property name="user" value="root"/>
		<property name="password" value="123456"/>
		<property name="minimumConnectionCount" value="2"/>
		<property name="maximumConnectionCount" value="10"/>
		<property name="prototypeCount" value="5"/>
		<!-- <property name="houseKeepingSleepTime" value="100000"/> -->
         	</bean>

 	<bean id="sessionFactory"
           		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
          		<property name="configLocation" value="classpath:Hibernate.cfg.xml"/>
          		<span><property name="dataSource">
          			<ref local="dataSource"/>
          		</property>
</span>           </bean>

  <servlet>   
        <servlet-name>ServletConfigurator</servlet-name>   
        <servlet-class>   
            org.logicalcobwebs.proxool.configuration.ServletConfigurator   
        </servlet-class>   
        <init-param>   
            <param-name>xmlFile</param-name>   
            <param-value>WEB-INF/classes/proxool.xml</param-value>   
        </init-param>   
        <load-on-startup>1</load-on-startup>   
  </servlet>
 

以上的配置就不在需要在web.xml中进行配置。

而在hibernate.cfg.xml中也不在需要proxool的配置只是配置一些hibernate的信息例如：

<pre class="brush:php;toolbar:false;">	<property name="show_sql">true</property>
	<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

和一些实体类的映射文件：

 <mapping resource="com/wuda/hibernate/table/users.hbm.xml"/>

以上就将SSH2+PROXOOL的环境搭建好了。

但是在搭建好之后如果我们配置<property name="houseKeepingSleepTime" value="100000"/>

又会提示如下错误：

Invalid property 'houseKeepingSleepTime' of bean class [org.logicalcobwebs.proxool.ProxoolDataSource]: Bean property 'houseKeepingSleepTime' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

大概意思是说'houseKeepingSleepTime'属性是不能够写的或者没有合适的setter方法。在他的参数setter和getter的返回结果类型不一致所导致的。

这个我想也正是他的bug吧。

那么具体解决如下:

在proxool-0.9.1.jar(我用的proxool架包)中找到org.logicalcobwebs.proxool.ProxoolDataSource将其源码修改如下：

源码是：

1./**  
2.    * @see ConnectionPoolDefinitionIF#getHouseKeepingSleepTime  
3.    */  
4.   public long getHouseKeepingSleepTime() {   
5.       return houseKeepingSleepTime;   
6.   }   
7.  
8.   /**  
9.    * @see ConnectionPoolDefinitionIF#getHouseKeepingSleepTime  
10.    */  
11.   public void setHouseKeepingSleepTime(int houseKeepingSleepTime) {   
12.       this.houseKeepingSleepTime = houseKeepingSleepTime;   
13.   }  

修改为：

<ol><li><span><span>/** </span> </span></li><li><span><span>    * @see ConnectionPoolDefinitionIF#getHouseKeepingSleepTime </span> </span></li><li><span><span>    */</span><span>  </span></span></li><li><span>   </span><span>public</span><span> </span><span>long</span><span> getHouseKeepingSleepTime() {   </span></li><li><span>       </span><span>return</span><span> houseKeepingSleepTime;   </span></li><li><span>   }   </span></li><li><span>  </span></li><li><span>   </span><span>/** </span> </li><li><span><span>    * @see ConnectionPoolDefinitionIF#getHouseKeepingSleepTime </span> </span></li><li><span><span>    *此处将int类型改为long类型 </span> </span></li><li><span><span>    */</span><span>  </span></span></li><li><span>   </span><span>public</span><span> </span><span>void</span><span> setHouseKeepingSleepTime(</span><span>long</span><span> houseKeepingSleepTime) {   </span></li><li><span>       </span><span>this</span><span>.houseKeepingSleepTime = houseKeepingSleepTime;   </span></li><li><span>   }  </span></li></ol>

这样所有问题都解决！

以上所有步骤都是通过本人在网上查资料，自己手动配置而成。验证通过！