ssh,s2sh中proxool监听方式配置

1.加入proxool-0.9.1.jar, proxool-cglib.jar，proxoolListenerConfig.jar包

2.Web.xml中配置监听

 <!-- proxool连接池 -->

  <context-param>

    <param-name>proxoolConfigLocation</param-name>

    <param-value>WEB-INF/classes/proxool.xml</param-value>

  </context-param>

  <listener>

    <listener-class>com.osekj.util.ProxoolListenerConfig</listener-class>

  </listener>

  <!-- 监控数据库连接池的连接情况 -->

  <servlet>

    <servlet-name>Admin</servlet-name>

    <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>

  </servlet>

  <servlet-mapping>

    <servlet-name>Admin</servlet-name>

    <url-pattern>/admin</url-pattern>

  </servlet-mapping> 

3.在src下 加入proxool.xml

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>oaproxool</alias>
<driver-url>jdbc:oracle:thin:@localhost:1521:oskj</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="osekjoa" />
<property name="password" value="123" />
</driver-properties>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>5</minimum-connection-count>
<prototype-count>5</prototype-count>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>300</maximum-new-connections>
<simultaneous-build-throttle>80</simultaneous-build-throttle>
<maximum-active-time>300000</maximum-active-time>
<maximum-connection-lifetime>14400000</maximum-connection-lifetime>
<test-before-use>true</test-before-use>
<house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>
</proxool>
</something-else-entirely>

4. Spring中配置datasource

<bean id="dataSource"  class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
    <property name="driverClassName"> 
    <value>org.logicalcobwebs.proxool.ProxoolDriver</value> 
    </property> 
    <property name="url"> 
    <value>proxool.oaproxool</value> 
    </property> 
    </bean> 

享受吧