[请教] 如何将P6spy,sqlprofiler 结合到Spring+Hibernate中

applicationContext.xml
<!-- P6SPY dataSource target -->      
<bean id="dataSourceTarget" class="org.springframework.jdbc.datasource.DriverManagerDataSource">      
 <property name="driverClassName" value="com.p6spy.engine.spy.P6SpyDriver" />
 <property name="url" value="jdbc:oracle:thin:@x.x.x.x:1521:x" />
 <property name="username" value="xxx" />
 <property name="password" value="xxx" />
</bean>
  
<!--  dataSource -->      
<bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource" destroy-method="close">
 <constructor-arg>

spy.properties
module.log=com.p6spy.engine.logging.P6LogFactory
realdriver=oracle.jdbc.driver.OracleDriver
deregisterdrivers=true
filter=false
autoflush=true
excludecategories=info,debug,result,batch
reloadproperties=false
reloadpropertiesinterval=60
useprefix=false
appender=com.p6spy.engine.logging.appender.Log4jLogger
logfile=../logs/x-spy.log
append=true
log4j.appender.SQLPROFILER_CLIENT=org.apache.log4j.net.SocketAppender
log4j.appender.SQLPROFILER_CLIENT.RemoteHost=localhost
log4j.appender.SQLPROFILER_CLIENT.Port=4445
log4j.appender.SQLPROFILER_CLIENT.LocationInfo=true
log4j.logger.p6spy=DEBUG, SQLPROFILER_CLIENT

 <ref local="dataSourceTarget"/>
 </constructor-arg>  
</bean>

WEB-INF/lib
p6spy.jar
sqlprofiler.jar

启动错误
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@x.x.x.x:x
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:281)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:269)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:253)
......

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值