proxool 连接池配置与注意事项
需要jar包：
proxool-0.9.1.jar
proxool-cglib.jar
第一步：
spring配置文件：
<bean id="dataSource" destroy-method="close"> <property name="driver"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="driverUrl"> <value>jdbc:oracle:thin:@192.168.21.252:1521:orcl</value> </property> <property name="user"> <value>bj_ceshi</value> </property> <property name="password"> <value>bj_ceshi</value> </property> <property name="alias"> <value>jcs_Proxool</value> </property> <property name="prototypeCount"> <value>2</value> </property> <property name="maximumConnectionCount"> <value>30</value> </property> <property name="minimumConnectionCount"> <value>2</value> </property> <property name="houseKeepingTestSql"> <value>select 1 from dual</value> </property> <property name="maximumActiveTime"> <value>30000</value> </property> </bean>
?sessionFactory配置是org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean
还是org.springframework.orm.hibernate3.LocalSessionFactoryBean都没有问题
?
第二步：配置监控页面
?
在web.xml新增servlet配置
<servlet>
?????? <servlet-name>proxooladmin</servlet-name>
?????? <servlet-class>
?????????? org.logicalcobwebs.proxool.admin.servlet.AdminServlet
?????? </servlet-class>
??? </servlet>
??? <servlet-mapping>
?????? <servlet-name>proxooladmin</servlet-name>
?????? <url-pattern>/proxooladmin</url-pattern>
??? </servlet-mapping>
?
??? <security-constraint>
?????? <web-resource-collection>
?????????? <web-resource-name>proxool</web-resource-name>
?????????? <url-pattern>/proxooladmin</url-pattern>
??? ??? </web-resource-collection>
?????? <auth-constraint>
?????????? <role-name>manager</role-name>
?????? </auth-constraint>
??? </security-constraint>
??? <login-config>
?????? <auth-method>BASIC</auth-method>
?????? <realm-name>proxool manager Application</realm-name>
??? </login-config>
??? <security-role>
?????? <description>
?????????? The role that is required to log in to the Manager
?????????? Application
?????? </description>
?????? <role-name>manager</role-name>
??? </security-role>
然后tomcat-user.xml中配置用户
<?xml version='1.0' encoding='utf-8'?>
<tomcat-users>
? <role rolename="manager"/>
? <user username="admin" password="123" roles="manager"/>
</tomcat-users>
?
只有tomcat的manager（web.xml配置）角色的用户才可以查看监控页面
?
访问http://localhost:8090/jc6/proxooladmin就可以查看监控页面了
?
?
如果用官方提供的jar包，在tomcat6下监控页面 快照页面会乱码
我对源码中adminServlet做了编码修改，用我提供的包就 没问题了
?