proxool 和web.xml配置

xml 代码

1. proxool.xml   
2.   
3. <?xml version="1.0" encoding="UTF-8"?>  
4.   
5. <!-- the proxool configuration can be embedded within your own application's.   
6. Anything outside the "proxool" tag is ignored. -->  
7. <something-else-entirely>  
8.   
9.   
10.    <!-- My database localhost infoMessage  -->  
11.   <proxool>  
12.     <alias>myself</alias>  
13.     <driver-url>jdbc:oracle:thin:@localhost:1521:oracle9</driver-url>  
14.     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>  
15.     <driver-properties>  
16.       <property name="user" value="scott"/>  
17.       <property name="password" value="tiger"/>  
18.     </driver-properties>  
19.     <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>  
20.     <minimum-connection-count>0</minimum-connection-count>  
21.     <maximum-connection-count>200</maximum-connection-count>  
22.     <maximum-active-time>300000</maximum-active-time>  
23.     <maximum-connection-lifetime>3600000</maximum-connection-lifetime>  
24.     <verbose>true</verbose>  
25.     <trace>true</trace>  
26.   </proxool>  
27.      
28.   
29.   
30.   <proxool>  
31.     <alias>mytest</alias>  
32.     <driver-url>jdbc:oracle:thin:@localhost:1521:oracle9</driver-url>  
33.     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>  
34.     <driver-properties>  
35.       <property name="user" value="test"/>  
36.       <property name="password" value="test"/>  
37.     </driver-properties>  
38.     <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>  
39.     <minimum-connection-count>0</minimum-connection-count>  
40.     <maximum-connection-count>200</maximum-connection-count>  
41.     <maximum-active-time>300000</maximum-active-time>  
42.     <maximum-connection-lifetime>3600000</maximum-connection-lifetime>  
43.     <verbose>true</verbose>  
44.     <trace>true</trace>  
45.   </proxool>  
46.   
47.   
48.   
49.     <!-- test for pci islp -->  
50.   <proxool>  
51.     <alias>pci_test</alias>  
52.     <driver-url>jdbc:oracle:thin:@172.19.8.5:1521:pcia</driver-url>  
53.     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>  
54.     <driver-properties>  
55.       <property name="user" value="pciback"/>  
56.       <property name="password" value="pciback"/>  
57.     </driver-properties>  
58.     <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql>  
59.     <minimum-connection-count>0</minimum-connection-count>  
60.     <maximum-connection-count>200</maximum-connection-count>  
61.     <maximum-active-time>300000</maximum-active-time>  
62.     <maximum-connection-lifetime>3600000</maximum-connection-lifetime>  
63.     <verbose>true</verbose>  
64.     <trace>true</trace>  
65.   </proxool>  
66.      
67.     
68.      
69. </something-else-entirely>  
70.   
71.   
72.   
73. web.xml   
74.   
75.   
76. <?xml version="1.0" encoding="UTF-8"?>  
77. <web-app version="2.4"    
78.     xmlns="http://java.sun.com/xml/ns/j2ee"    
79.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    
80.     xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee    
81.     http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">  
82.        
83.     <servlet>  
84. <servlet-name>ServletConfigurator</servlet-name>  
85. <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>  
86. <init-param>  
87. <param-name>xmlFile</param-name>  
88. <param-value>WEB-INF/proxool.xml</param-value>  
89. </init-param>  
90. <load-on-startup>1</load-on-startup>  
91. </servlet>  
92.   
93. <servlet>  
94. <servlet-name>Admin</servlet-name>  
95. <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>  
96. </servlet>  
97. <servlet-mapping>  
98. <servlet-name>Admin</servlet-name>  
99. <url-pattern>/admin</url-pattern>  
100. </servlet-mapping>  
101.        
102.   <welcome-file-list>  
103.     <welcome-file>index.jsp</welcome-file>  
104.   </welcome-file-list>  
105. </web-app>