Hi, Hum, last year i tried P6SPY and find a big bug. queries don't work as they would do. I already talked about that in that forum.
And, we have to time in production (P6SPY is not recommended for that). Well, i wrote some code in JdbcAccessImpl.java and i well get usefull times. It get measures and sql request for executeQuery( ...) method , but not for method such executeUpdate(ClassDescriptor cd, Object o) because i didn't get the sql instruction ( UPDATE TABLE SET XXX=..." WHERE ... ). How can i reach the sql instruction? Measuring time without the query is a little useless . A fine cast may be ? Thanks. Regards. On 12/15/06, Charles Anthony <[EMAIL PROTECTED]> wrote:
Hi, Another option would be to use the p6spy jdbc driver http://www.p6spy.com/ which, if I remember correctly logs the time taken to execute the statement as well as the statement itself. Cheers, Charles. > -----Original Message----- > From: Armin Waibel [mailto:[EMAIL PROTECTED] > Sent: 15 December 2006 01:24 > To: OJB Users List > Subject: Re: Which class to modify to clock sql statements ? > > Bruno CROS wrote: > > Hi, > > > > Well, i just want to mesure the time a sql statement takes > to be post > > (sql commit too). I looked a bit in broker.accesslayer > package and in > > StatementForClassImpl.java. Is it the right place to do this ? > > > > I would recommend to have a look in class JdbcAccessImpl to > clock query execution time. > > regards, > Armin > > > May be someone wrote an implementation? > > > > Working with 1.0.4.... > > > > Thanks for advices. > > > > Regards. > > > > --------------------------------------------------------------------- > 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]
