The following is how to use it:
1) download to http://sourceforge.net/projects/proxool/ and configure to project
2) use web-INF/proxool. XML to configure connection pool attributes
<? XML version = "1.0" encoding = "ISO-8859-1"?> <! -- The proxool configuration can be embedded within your own application/'s. Anything outside the "proxool" tag is ignored. -->
<Something-else-entirely>
<Proxool>
<Alias> XML-test </alias>
<Driver-URL> JDBC: mysql: // 172.18.16.3: 3306/newwapnotinno </driver-URL> <driver-class> Org. gjt. mm. mySQL. driver </driver-class>
<Driver-Properties>
<Property name = "user" value = "root"/>
<Property name = "password" value = ""/>
</Driver-Properties>
<Maximum-connection-count> 100 </maximum-connection-count>
<House-keeping-test-SQL> select current_date </Proxool>
</Something-else-entirely>
3) Configure to read proxool. XML in Web. XML, which is equivalent
Jaxpconfigurator. Configure ("proxool. xml", false ).
<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>
4) for connection information, see org. logicalcobwebs. proxool. Examples. Simple.
The following is the monitoring method:
1) Configure adminservlet in Web. xml:
<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>
2) Use http: // localhots/Web-name/admin to access the Monitored results.