需要jar包:
proxool-0.9.1.jar
proxool-cglib.jar
第一步:
spring配置文件:
<bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource" 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做了编码修改,用我提供的包就 没问题了