需要包
P6SPY http://p6spy.sourceforge.net
spy.properties
################################################################################
module.log=com.p6spy.engine.logging.P6LogFactory
realdriver=org.gjt.mm.mysql.Driver
#specifies another driver to use
realdriver2=
#specifies a third driver to use
realdriver3=
deregisterdrivers=false
executionthreshold=
outagedetection=false
outagedetectioninterval=
# filter what is logged
filter=false
include =
exclude =
sqlexpression =
# turn on tracing
autoflush = true
dateformat=
includecategories=
#list of categories to exclude: error, info, batch, debug, statement,
#commit, rollback and result are valid values
excludecategories=info,debug,result,batch
stringmatcher=
# prints a stack trace for every statement logged
stacktrace=false
# if stacktrace=true, specifies the stack trace to print
stacktraceclass=
# determines if property file should be reloaded
reloadproperties=false
# determines how often should be reloaded in seconds
reloadpropertiesinterval=60
#if=true then url must be prefixed with p6spy:
useprefix=false
appender=com.p6spy.engine.logging.appender.FileLogger
# name of logfile to use, note Windows users should make sure to use forward slashes in their pathname (e:/test/spy.log) (used for file logger only)
logfile = spy.log
append=true
#The following are for log4j logging only
log4j.appender.STDOUT=org.apache.log4j.ConsoleAppender
log4j.appender.STDOUT.layout=org.apache.log4j.PatternLayout
log4j.appender.STDOUT.layout.ConversionPattern=p6spy - %m%n
log4j.logger.p6spy=INFO,STDOUT
################################################################################
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*
* 项目名称: 2006-3-4
*/
public class TestConnMysqlWithSpy {
/**
* @param args
*/
public static void main(String[] args) {
try {
Class.forName("com.p6spy.engine.spy.P6SpyDriver").newInstance();
}
catch (Exception E) {
System.err.println("Unable to load driver.");
}
try {
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=&useUnicode=true&characterEncoding=GBK");
Statement s=C.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=s.executeQuery("select * from abc");
int i=1;
for (i=10;i<20;i++)
{
if (rs.next())
{
System.err.println(rs.getString(1));
}
}
rs.close();
s.close();
C.close();
}
catch (SQLException E) {
System.err.println("SQLException: " + E.getMessage());
System.err.println("SQLState: " + E.getSQLState());
System.err.println("VendorError: " + E.getErrorCode());
}
}
}
下载
分享到:
相关推荐
P6Spy 用 Log4J 来记录 JDBC 调用的日记信息。 自从 2003 年 11 月 30 日 P6Spy 版本 1.3 发布后,已经被下载超过 19,000 次了。P6Spy 支持 WebSphere、WebLogic、JBoss、Resin 和 Tomcat 等绝大多数的应用服务器。
P6spy是一个JDBC Driver的包装工具,p6spy通过对JDBC Driver的封装以达到对SQL语句的监听和分析,以达到各种目的。 p6spy的安装步骤: 1. 下载p6spy的安装包 2. 把p6spy的jar包放到Classpath中,如果是WEB App...
p6spy.jar 博文链接:https://lxy19791111.iteye.com/blog/131293
p6spy-sql监控 p6spy-sql监控 p6spy-sql监控
p6spy监控jdbc连接oracle查看执行时长,使用配置说明
监控和剖析数据库 P6Spy、SQL Profiler、IronTrack SQL。三个东东打包放送,另附配置说明
内含p6spy-3.6.0.zip,p6spy最新Hibernate和Mybatis拦截并格式化sql配置.txt两个文件,用于调试监控项目运行状态,亲测可用,测试整理出来花了我很长时间的,好用不可多得!
p6spy
p6spy简介,p6spy完整显示hibernate的SQL语句 包括参数,spring p6spy 配置
# realdriver=oracle.jdbc.driver.OracleDriver # mysql Connector/J driver # realdriver=com.mysql.jdbc.Driver # informix driver # realdriver=com.informix.jdbc.IfxDriver # ibm db2 driver # realdriver=...
wildfly添加p6spy wildfly添加p6spy wildfly添加p6spy wildfly添加p6spy
p6spy使用 sql跟踪 排除resultset 去掉问号
利用P6SPY +SQL Profiler调试、记录、统计web app对数据库的操作, 可以查看到PreparedStatment的执行最终的SQL语句。 有详细的操作说明 下面的这个是集成的完整版。。太大了就不上传了。自己下吧 jahia_v6_...
这是自己整合的Spring 3.0+Struts2+Mybatis 3 + p6spy +ehcache的平台框架,内含一点示例代码,目前ehcache没有使用。直接编译后发布就能用 测试环境基于JDK1.6+Tomcat 6.0. 大家拿到后请根据实际情况修改 ...
集成P6spy 一 系统集成P6spy