springMVC 集成P6Spy

2019独角兽企业重金招聘Python工程师标准>>>

1,修改 $CATALINA_BASE/conf/server.xml

<Resource name="jdbc/mydb2"  auth="Container"
            type="javax.sql.DataSource"
            username="root"
            password="111111"
            driverClassName="com.p6spy.engine.spy.P6SpyDriver"
            url="jdbc:p6spy:mysql://127.0.0.1:3306/pua"
            maxActive="8"
            maxIdle="4"
initialSize="1"
            />

2.$CATALINA_BASE/conf/context.xml

<ResourceLink name="jdbc/mydb2"
         global="jdbc/mydb2"
         type="javax.sql.DataSource"/>

3, 增加文件webapps/convention2/META-INF/context.xml(此步不需要)

<?xml version="1.0" encoding="UTF-8"?>
         <Context path="/"  reloadable="true" debug="1">
         <Resource name="jdbc/mydb2"  auth="Container"
            type="javax.sql.DataSource"
            username="root"
            password="111111"
            driverClassName="com.p6spy.engine.spy.P6SpyDriver"
            url="jdbc:p6spy:mysql://127.0.0.1:3306/pua"
            maxActive="8"
            maxIdle="4"
initialSize="1"
            />
         </Context>

4.修改$CATALINA_BASE/lib/spy.properties

realdriver =com.mysql.jdbc.Driver

driverlist=com.mysql.jdbc.Driver

logfile = ../logs/spy4.log # 相对的当前路径是bin目录

日志文件路径:$CATALINA_BASE/logs/spy4.log

5.修改webapps/convention2/WEB-INF/classes/beans.xml

<bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource">
  <constructor-arg>
    <bean id="DataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
      <property name="jndiName" value="java:comp/env/jdbc/mydb2"/>
    </bean>
  </constructor-arg>
</bean>

6,把P6Spy 相关的jar 拷贝到$CATALINA_BASE/lib中,包括MySQL 数据库驱动

 

注意:

(1)convention2 是我的项目名称;

(2)p6spy.jar , spy.properties,mysql-connector-java-5.1.5-bin.jar必须放在$CATALINA_BASE/lib 中.

(3)spring 配置文件beans.xml中的"jndiName"必须是"java:comp/env/jdbc/mydb2",而不是"/jdbc/mydb2".

转载于:https://my.oschina.net/huangweiindex/blog/1518952