spring boot应用p6spy监控sql

Spring boot中使用p6spy监控hibernate sql语句值

开发环境

• 开发工具：IDEA
• 开发环境：spring mvc、spring boot、spring data
• 数据库:mysql

具体步骤如下：

• pom.xml中添加p6spy包依赖：

        <dependency>
            <groupId>p6spy</groupId>
            <artifactId>p6spy</artifactId>
            <version>3.0.0</version>
        </dependency>

• application.yml配置中：

(1). url中必须增加p6spy,才能对SQL进行拦截：

jdbc:p6spy:mysql://192.0.6.116:3066/testdb

(2). driver-class需替换为：

com.p6spy.engine.spy.P6SpyDriver

具体如下：

spring:
  datasource:
    url: jdbc:p6spy:mysql://192.0.6.116:3066/testdb
    #driver-class-name: com.mysql.jdbc.Driver
    driver-class-name: com.p6spy.engine.spy.P6SpyDriver
    username: root
    password: xxxxxx

• 将spy.properties放到resources根目录下

spy.properties文件内容参考如下：

###
# #%L
# P6Spy
# %%
# Copyright (C) 2013 P6Spy
# %%
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
# 
#      http://www.apache.org/licenses/LICENSE-2.0
# 
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
# #L%
###

#################################################################
# P6Spy Options File                                            #
# See documentation for detailed instructions                   #
# http://p6spy.github.io/p6spy/2.0/configandusage.html          #
#################################################################

#################################################################
# MODULES                                                       #
#                                                               #
# Module list adapts the modular functionality of P6Spy.        #
# Only modules listed are active.                               #
# (default is com.p6spy.engine.logging.P6LogFactory and         #
# com.p6spy.engine.spy.P6SpyFactory)                            #
# Please note that the core module (P6SpyFactory) can't be      # 
# deactivated.                                                  #
# Unlike the other properties, activation of the changes on     #
# this one r