一、p6spy.jar添加到了lib目录下
二、spy.properties添加到了src目录下
realdriver=oracle.jdbc.driver.OracleDriver
logfile=C:/spy.log
三、Spring配置文件
<bean id="dataSourceTarget" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="username" value="yu"/>
<property name="password" value="abc"/>
</bean>
<bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource">
<constructor-arg>
<ref local="dataSourceTarget"/>
</constructor-arg>
</bean>启动Tomcat服务,控制台不报错,spy.log日志文件不出现,运行的时候就报下面的错误
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orcl或是SH项目报下面的错:
org.hibernate.exception.JDBCConnectionException: Cannot open connection
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orcl
二、spy.properties添加到了src目录下
realdriver=oracle.jdbc.driver.OracleDriver
logfile=C:/spy.log
三、Spring配置文件
<bean id="dataSourceTarget" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="username" value="yu"/>
<property name="password" value="abc"/>
</bean>
<bean id="dataSource" class="com.p6spy.engine.spy.P6DataSource">
<constructor-arg>
<ref local="dataSourceTarget"/>
</constructor-arg>
</bean>启动Tomcat服务,控制台不报错,spy.log日志文件不出现,运行的时候就报下面的错误
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orcl或是SH项目报下面的错:
org.hibernate.exception.JDBCConnectionException: Cannot open connection
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orcl
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货