在spring的applicationContext中配置proxool连接池
我使用的mysql数据库：
applicationContext.xml
<bean id="dataSource"?? encoding="UTF-8"?>
<proxool-config>
?? <proxool>
????? <!-- 配置连接池的别名 -->
????? <alias>DBPool</alias>
????? <driver-url>jdbc:mysql://192.168.1.200:3306/beijing2008?autoReconnect=true&useUnicode=true&characterEncoding=utf-8</driver-url>
????? <driver-class>com.mysql.jdbc.Driver</driver-class>
????? <driver-properties>
???????? <property name="user" value="ugo"/>
???????? <property name="password" value="ugo"/>
????? </driver-properties>
????? <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 -->
????? <house-keeping-sleep-time>90000</house-keeping-sleep-time>
????? <maximum-new-connections>150</maximum-new-connections>
????? <!-- 最少保持的空闲连接数 -->
????? <prototype-count>3</prototype-count>
????? <!-- 最大连接数 -->
????? <maximum-connection-count>100</maximum-connection-count>
????? <!-- 最小连接数 -->
????? <minimum-connection-count>3</minimum-connection-count>
?? </proxool>
</proxool-config>??
web.xml(注意看清配置，是你少走弯路)
?? <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>
??? <servlet>
??????? <servlet-name>contextConfigLocation</servlet-name>
??????? <servlet-class>
?????????? org.springframework.web.context.ContextLoaderServlet
?????? </servlet-class>
?????? <load-on-startup>2</load-on-startup>
?? </servlet>
?? <context-param>
?????? <param-name>contextConfigLocation</param-name>
?????? <param-value>/WEB-INF/applicationContext.xml</param-value>
</context-param>
不可以使用这样的配置：
?????? <!--<listener>
?? <listener-class>
??? org.springframework.web.context.ContextLoaderListener
?? </listener-class>
</listener>-->
