proxool 连接池实例

期间 有可能出现org.logicalcobwebs.proxool.ProxoolException: Attempt to refer to a unregistered

后面把

    <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/proxool.xml</param-value>   
        </init-param>   
        <load-on-startup>1</load-on-startup>   
    </servlet>  

替换成

	<context-param>
		<param-name>proxoolConfigLocation</param-name>
		<param-value>WEB-INF/proxool.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.logicalcobwebs.proxool.configuration.ListenerConfigurator</listener-class>
	</listener>
	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 	 </listener>

所需要的包 在  附件中



至于配置文件 方面 就不多说咯，网上一搜一大把

proxool.alias=Test
proxool.driver-class=oracle.jdbc.driver.OracleDriver
proxool.driver-url=jdbc:oracle:thin:@192.168.10.160:1521:orcl
proxool.user=test
proxool.password=testpass
proxool.maximum-connection-count=20
proxool.prototype-count=4
proxool.house-keeping-test-sql=select sysdate from DUAL
proxool.verbose=true
proxool.statistics=10s,1m,1d
proxool.statistics-log-level=ERROR.

maximum-connection-lifetime   最大连接生命周期 默认值：4小时
maximum-active-time：     最大活动时间   默认值：5分钟
maximum-connection-count   最大连接数    默认值：15个
minimum-connection-count   最小连接数    默认值：5个