星星公园

1、新建web-inf/proxool.xml配置连接池属性
    proxool支持多配置方式如property，javabean等
  <? xml version="1.0" encoding="ISO-8859-1" ?>
< something-else-entirely >
< proxool >
  < alias > oracle </ alias >
  < driver-url > jdbc:oracle:thin:@130.51.65.10:1521:xxxxx </ driver-url >
  < driver-class > oracle.jdbc.OracleDriver </ driver-class >
  < driver-properties >
    < property name ="user" value ="xxxxxxxx" />
    < property name ="password" value ="xxxxx" />
  </ driver-properties >
  < maximum-connection-count > 100 </ maximum-connection-count >
  < house-keeping-test-sql > select 1 from dual </ house-keeping-test-sql >
</ proxool >
</ something-else-entirely >
2、在web.xml中配置读取proxool.xml；这个相当于程序中使用
  JAXPConfigurator.configure("proxool.xml", false)。
  在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 >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]   </ servlet >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]   < servlet >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]     < servlet-name > Admin </ servlet-name >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]     < servlet-class > org.logicalcobwebs.proxool.admin.servlet.AdminServlet </ servlet-class >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]   </ servlet >
3）web.xml中配置adminservlet:
    adminservlet的作中是监控连接池的运行状况。
< servlet >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]     < servlet-name > Admin </ servlet-name >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]     < servlet-class > org.logicalcobwebs.proxool.admin.servlet.AdminServlet </ servlet-class >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]   </ servlet >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]   < servlet-mapping >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]     < servlet-name > Admin </ servlet-name >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]     < url-pattern > /Admin </ url-pattern >
[img]http://www.blogjava.net/Images/OutliningIndicators/None.gif[/img]   </ servlet-mapping >