在spring中配置proxool连接池

applicationContext-hibernate.xml： <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> …… <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">  org.hibernate.dialect.Oracle9Dialect </prop> <prop key="hibernate.show_sql">false</prop> <prop key="hibernate.generate_statistics">true</prop> <prop key="hibernate.cglib.use_reflection_optimizer">true</prop> <prop key="hibernate.proxool.xml">com/cinwa/creditnet/entity/proxool.xml</prop> <prop key="hibernate.proxool.pool_alias">DBPool</prop> </props> </property> …… </bean>

proxool.xml： <?xml version="1.0" encoding="UTF-8"?> <proxool-config>  <proxool>   <alias>DBPool</alias>   <driver-url>jdbc:oracle:thin:@192.168.1.6:1521:orcl</driver-url>   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>   <driver-properties>    <property name="user" value="d21315" />    <property name="password" value="d21315" />   </driver-properties>      proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁。   <house-keeping-sleep-time>90000</house-keeping-sleep-time>   指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受。   <maximum-new-connections>20</maximum-new-connections>   最少保持的空闲连接数。  -->   <prototype-count>5</prototype-count>   允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定   <maximum-connection-count>50</maximum-connection-count>   最小连接数   <minimum-connection-count>10</minimum-connection-count>

  <house-keeping-test-sql>    select 1 from dual   </house-keeping-test-sql>  </proxool> </proxool-config>

F:\workspace\cinwa\webapp\WEB-INF\lib ：proxool-0.8.3.jar