用P6SPY测试程序

运行环境Tomcat5.5.16,Windows2000 Adv

程序架构Spring+hibernate

首先从www.p6spy.com下载jar文件,下载最新软件包p6spy-install.zip,从压缩包中取出p6spy.jar和spy.properties文件.

把p6spy.jar放到classpath下,我是放到project下的WEB/INF/lib里,把spy.properties放到src/下.

打开hibernate.xml,我的是application-hibernate.xml,进行如下配置

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<!--    <property name="driverClassName"><value>net.sourceforge.jtds.jdbc.Driver</value></property> -->
        <property name="driverClassName"><value>com.p6spy.engine.spy.P6SpyDriver</value></property>
        <property name="url"><value>jdbc:jtds:sqlserver://127.0.0.1:1433/jspd10</value></property>
        <property name="username"><value>sa</value></property>
        <!-- Make sure <value> tags are on same line - if they're not,
             authentication will fail -->
        <property name="password"><value></value></property>
    </bean>

绿字为以前的driver,红字为替换后的

接下来在spy.properties下的realdriver加上

# sql servler Driver
  realdriver=net.sourceforge.jtds.jdbc.Driver

这里的realdriver是绿字的

我的是windows系统,所以我把log文件放在D:/spy.log下

# 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     = d:/spy.log

重新启动Tomcat,发现D盘下存在spy.log,运行程序产生log,配置完毕