Re: P6Spy SQL tracing with the JDBC connector
Posted by: Mark Matthews
Date: January 13, 2005 09:35AM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: P6Spy SQL tracing with the JDBC connector
January 13, 2005 09:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.