Alistair Black wrote:
> Hi,
>
> I've just migrated a Sybase ASA database onto
> MySQL which is being used from the Orion
> application server. I was able to trace all SQL
> over the JDBC connection against ASA using P6Spy,
> so would like to do the same against MySQL.
>
> In my Orion datasources configuration file I've
> set the datasource class to
> "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPool
> DataSource" and the connection-driver to
> "com.p6spy.engine.spy.P6SpyDriver". I've then set
> the realdriver property within my spy.properties
> file to "com.mysql.jdbc.Driver".
>
Alistair,
You're mixing a DataSource with a driver there. My guess is for P6spy to work, it needs to replace a _driver_ not a datasource, so only configure for a Driver-based connection pool/datasource, not a ConnectionPoolDataSource-based pool.
(In any case, you might also want to try our built-in query trace/log facility that is enabled using the JDBC url property 'profileSQL=true'.)
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html