JDBC监听器-P6Spy

JDBC监听器-P6Spy

sf2gis@163.com

2015年12月7日

 

1  目标：监听JDBC对数据库的修改，并显示相关的SQL。

2 原理：封装JDBC驱动，监听JDBC调用。

3 流程：下载，安装，配置，结果查看。

参考：http://www.iteye.com/topic/4143

3.1 下载：从SourceForge中下载p6spy-install.jar。

http://sourceforge.net/projects/p6spy/?source=typ_redirect

注意：不要下载github中的zip。

3.2 安装：解压后，将pyspy.jar复制到工程的buildpath。将spy.properties复制到src目录。

3.3 配置：配置spy.properties和hibernate。

基本上保持spy.properties的默认值，只需修改

真正的驱动：realdriver=com.mysql.jdbc.Driver。

注销驱动注册（如果注册早了，会使用真正的驱动，无法监听）：deregisterdrivers=true

//spy.properties

#################################################################

# P6Spy Options File                                            #

# See documentation fordetailed instructions                   #

#################################################################

 

#################################################################

# MODULES                                                      #

#                                                              #

# Modules provide the P6Spyfunctionality.  If a module, such   #

# as module_log is commentedout, that functionality will not   #

# be available.  If it is not commented out (if it isactive),  #

# the functionality will beactive.                             #

#                                                               #

# Values set in Modulescannot be reloaded using the            #

# reloadpropertiesvariable.  Once they are loaded, theyremain #

# in memory until theapplication is restarted.                #

#                                                               #

#################################################################

 

module.log=com.p6spy.engine.logging.P6LogFactory

#module.outage=com.p6spy.engine.outage.P6OutageFactory

 

#################################################################

# REALDRIVER(s)                                                #

#                                                              #

# In your application serverconfiguration file you replace the #

# "real driver"name with com.p6spy.engine.P6SpyDriver. This is #

# where you put the name ofyour real driver P6Spy can find and #

# register your real driverto do the database work.            #

#                                                              #

# If your application usesseveral drivers specify them in      #

# realdriver2,realdriver3.  See the documentation formore     #

# details.                                                     #

#                                                              #

# Values set in REALDRIVER(s)cannot be reloaded using the      #

# reloadpropertiesvariable.  Once they are loaded, theyremain #

# in memory until theapplication is restarted.                #

#