Well, i added: com.mysql.jdbc.Driver a = new com.mysql.jdbc.Driver(); com.p6spy.engine.spy.P6SpyDriver b = new com.p6spy.engine.spy.P6SpyDriver();
Just to verify that it was all there, and it came up with a different error - couldnt find spy.properties in the classpath! Copied that accross, and it seems to be working. In the faq i found it doesnt mention that you need to copy this file into the classpath! Daniel. > -----Original Message----- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: 07 December 2004 19:28 > To: OJB Users List > Subject: Re: p6spy > > > Daniel Perry wrote: > > Simple question - how do i use p6spy? > > > > I've recompiiled ojb with p6spy, and set mysql as the 'real' > driver. I've > > copied the jar file and p6spy's jar. > > > > p6spy, mysql driver jar really in classpath, typo in realdriver property? > Sorry, that's all cross my my mind ;-) > > Armin > > > > I've changed my repository to use p6spy (see below), and added > the driver: > > > > <jdbc-connection-descriptor > > jcd-alias="default" > > default-connection="true" > > platform="MySQL" > > jdbc-level="2.0" > > driver="com.p6spy.engine.spy.P6SpyDriver" > > protocol="jdbc" > > subprotocol="mysql" > > dbalias="//localhost/lecrossingpdp" > > username="" > > password="" > > batch-mode="false" > > > > > > > But i get the error: > > [org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR: > > Error getting Connection from DriverManager with url > > (jdbc:mysql://localhost/lecrossingpdp) and driver > > (com.p6spy.engine.spy.P6SpyDriver) > > No suitable driver > > java.sql.SQLException: No suitable driver > > at java.sql.DriverManager.getConnection(Unknown Source) > > at java.sql.DriverManager.getConnection(Unknown Source) > > at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.ne > wConnectio > > nFromDriverManager(ConnectionFactoryAbstractImpl.java:253) > > at > > > org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConP > oolFactory > > .makeObject(ConnectionFactoryPooledImpl.java:231) > > at > > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Generi > cObjectPoo > > l.java:816) > > ....... > > > > > > Any ideas? > > What have i missd? > > > > Thanks, > > Daniel. > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]