Java Development Tools

I am currently working on an OC4J application using Oracle db, with JDeveloper. I'm having some trouble with the DataSourceUserManager, in that it appears to be emitting faulty SQL, but I don't know exactly what SQL is being emitted. Today, I'm trying to see if I can interject the P6Spy JDBC driver on the database client side so I can see exactly what SQL is being emitted. I've successfully used P6Spy in the past on other projects, so I believe it can work, although I didn't use it with Oracle before.

Unfortunately, I'm having trouble figuring out how to inform JDeveloper of the location of the driver jar. I've added P6Spy as a library to my application, and I've found several XML files in my workspace and in the JDev configuration which contain an "orion-application" element, which contains "library" sub elements, several of which I've added "library" elements to specify the location of the driver jar. Despite that, when the embedded OC4J starts up, I still get this in the messages window:

Error initializing data-source 'jdbc/OracleDS': DriverManagerDataSource driver 'com.p6spy.engine.spy.P6SpyDriver' not found

Note that this occurs while OC4J is trying to initialize my UserManager subclass.

I believe there is also some facility for turning on "tracing" with Oracle, but the person who knows about that isn't here today. It would be good if I could get P6Spy working today, so I can make some progress today (which is looking more unlikely by the second).