proxool 连接池配置与注意事项

需要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做了编码修改，用我提供的包就 没问题了