proxool.xml配制文件,放入WEB-INF目录下,
<?xml version="1.0" encoding="ISO-8859-1"?>
<!--
使用SQL连接池
<prototype-count>连接池中可用的连接数量.如果当前的连接池中的连接少于这个数值.新的连接将被建立(假设没有超过最大可用数).
例如.我们有3个活动连接2个可用连接,而我们的prototype-count是4,那么数据库连接池将试图建立另外2个连接
maximum-active-time 每隔多少秒起动一个连接放入连接池
minimum-connection-count最小的数据库连接数,一般最好事先初始化一部分连接这样,对于初次连接数据库的应用效率比较高,推荐设置5-10
maximum-connection-lifetime 一个线程的最大寿命
house-keeping-test-sql如果发现了空闲的数据库连接.house keeper 将会用这个语句来测试.这个语句最好非常快的被执行.如果没有定义,测试过程将会被忽略
trace如果为true,那么每个被执行的SQL语句将会在执行期被log记录(DEBUG LEVEL)
-->
<something-else-entirely>
<proxool>
<alias>mssql</alias>
<driver-url>jdbc:jtds:sqlserver://192.168.2.77:1433/hbgds</driver-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="sa"/>
</driver-properties>
<house-keeping-sleep-time>900000</house-keeping-sleep-time>
<prototype-count>5</prototype-count>
<maximum-active-time>60000</maximum-active-time>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>5</minimum-connection-count>
<!--<maximum-connection-lifetime><maximum-connection-lifetime> -->
<house-keeping-test-sql>SELECT CURRENT_USER</house-keeping-test-sql>
<test-before-use>false</test-before-use>
<trace>true</trace>
<verbose>false</verbose>
<statistics>10s,15m,1d</statistics>
</proxool>
</something-else-entirely>
---------------------------------------
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>AdminServlet</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>AdminServlet</servlet-name>
<url-pattern>/Admin</url-pattern>
</servlet-mapping>
启动tomcat,一切OK
<?xml version="1.0" encoding="ISO-8859-1"?>
<!--
使用SQL连接池
<prototype-count>连接池中可用的连接数量.如果当前的连接池中的连接少于这个数值.新的连接将被建立(假设没有超过最大可用数).
例如.我们有3个活动连接2个可用连接,而我们的prototype-count是4,那么数据库连接池将试图建立另外2个连接
maximum-active-time 每隔多少秒起动一个连接放入连接池
minimum-connection-count最小的数据库连接数,一般最好事先初始化一部分连接这样,对于初次连接数据库的应用效率比较高,推荐设置5-10
maximum-connection-lifetime 一个线程的最大寿命
house-keeping-test-sql如果发现了空闲的数据库连接.house keeper 将会用这个语句来测试.这个语句最好非常快的被执行.如果没有定义,测试过程将会被忽略
trace如果为true,那么每个被执行的SQL语句将会在执行期被log记录(DEBUG LEVEL)
-->
<something-else-entirely>
<proxool>
<alias>mssql</alias>
<driver-url>jdbc:jtds:sqlserver://192.168.2.77:1433/hbgds</driver-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="sa"/>
</driver-properties>
<house-keeping-sleep-time>900000</house-keeping-sleep-time>
<prototype-count>5</prototype-count>
<maximum-active-time>60000</maximum-active-time>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>5</minimum-connection-count>
<!--<maximum-connection-lifetime><maximum-connection-lifetime> -->
<house-keeping-test-sql>SELECT CURRENT_USER</house-keeping-test-sql>
<test-before-use>false</test-before-use>
<trace>true</trace>
<verbose>false</verbose>
<statistics>10s,15m,1d</statistics>
</proxool>
</something-else-entirely>
---------------------------------------
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>AdminServlet</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>AdminServlet</servlet-name>
<url-pattern>/Admin</url-pattern>
</servlet-mapping>
启动tomcat,一切OK