一、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