需要文件
  • web.xml
  • proxool.xml
  • lo4j2.xml

下載 解壓縮 取出需要的 jar檔

放入 webapps\ROOT\WEB-INF\lib
  • proxool-0.9.1.jar
  • proxool-cglib.jar
  • commons-logging-1.2.jar
  • log4j-1.2-api-2.8.2.jar (log4j 1.X 橋接 log4j 2.X)
  • log4j-api-2.8.2.jar
  • log4j-core-2.8.2.jar
  • mysql-connector-java-5.1.42-bin.jar


    • 編輯文件 web.xml

    webapps\ROOT\WEB-INF\web.xml

    加入貼上下面的內容


    <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>

      需要建立的文件
    • proxool.xml
    • lo4j2.xml

    建立 proxool.xml

    webapps\ROOT\WEB-INF\proxool.xml

    寫入貼上下面的內容


    <?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-db</alias>
      <driver-url>jdbc:mysql://127.0.0.1:3306/mytestdb</driver-url>
      <driver-class>org.gjt.mm.mysql.Driver</driver-class>
      <driver-properties>
       <property name="user" value="user"/>
       <property name="password" value="password"/>
      </driver-properties>
      <maximum-connection-count>99</maximum-connection-count>
      <house-keeping-test-sql> SELECT 1 + 1;</house-keeping-test-sql>
     </proxool>
    </something-else-entirely>

    建立 lo4j2.xml

    webapps\ROOT\WEB-INF\classes\lo4j2.xml

    寫入貼上下面的內容


    <?xml version="1.0" encoding="UTF-8" ?>
    <Configuration status="WARN">
     <Appenders >
      <console name="Console" target="SYSTEM_OUT">
        <PatternLayout pattern="[%d{HH:mm:ss:SSS}] [%p] - %l - %m%n"/>
        <ThresholdFilter level="info" onMatch="ACCEPT" onMismatch="DENY"/>
      </console>

      <RollingFile name="proxool.log" fileName="${sys:catalina.base}/logs/proxool.log4j2.log"
      filePattern="${sys:catalina.base}/logs/proxool.log4j2-%d{yyyy-MM-dd}-%i.log">
       <PatternLayout pattern="%d %-5p [%t] %C{2} (%F:%L) - %m%n"/>
       <ThresholdFilter level="info" onMatch="ACCEPT" onMismatch="DENY"/>
         <Policies>
            <TimeBasedTriggeringPolicy/>
            <SizeBasedTriggeringPolicy size="10 MB"/>
         </Policies>
      </RollingFile >
     </Appenders>

    <Loggers>
     <Root level="all">
       <AppenderRef ref="Console"/>
       <AppenderRef ref="proxool.log"/>
     </Root>
    </Loggers>
    </Configuration>

    Quick Start 範例

    User Guide http://proxool.sourceforge.net/user.html


    ...
               try{
                    Connection conn = DriverManager.getConnection("proxool.xml-db");
                    return conn;
                } catch (SQLException e){
                    System.out.println(e);
                }
    ...

    監看功能 Servlet(AdminServlet)

    webapps\ROOT\WEB-INF\web.xml

    加入貼上下面的內容


    <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>/admin</url-pattern>
    </servlet-mapping>

    測試連線 http://127.0.0.1:8080/admin




    注意事項:

    log4j jar檔放在 webapps\ROOT\WEB-INF\lib\
    lo4j2.xml 必須放在 webapps\ROOT\WEB-INF\classes\
    proxool官方文件文獻 有些勘誤,必須 Goolge 多驗證.