>From the p6spy website: "P6Log intercepts and logs the database statements of any application that uses JDBC. This application is particularly useful for developers to monitor the SQL statements..."
You could also use a profiler like Jprofiler or YourKit, both of which have the ability to log JDBC statements. On 11/30/07 4:16 PM, "Warren" <[EMAIL PROTECTED]> wrote: > Thanks, I will quit knocking myself out trying to get JDBC to log by itself. > p6spy, will this allow me to capture SQL statements. I am trying to rewrite > an old servlet/jsp app that is no longer supported. It would sure speed > things up if I could get my hands on the SQL. I do not have the source code > and I have decompiled it, but its a mess. I am trying to get request level > logging on the db side, but have not had any luck. It uses Sybase SQL > Anywhere 8.0.2. Any sugestions? > -----Original Message----- > From: Jeff Butler [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 1:42 PM > To: [email protected] > Subject: Re: Ibatis java.sql and log4j > > > iBATIS logs to the java.sql objects - so all the java.sql logging entries > you see are actually iBATIS entries - NOT standard java.sql entries. This > is a <sarcasm>feature</sarcasm> of iBATIS and will not be available in other > environments. > > Many JDBC drivers can be configured to do logging, or you can use p6spy, > in other environments. > > Jeff Butler > > > > > > On Nov 30, 2007 3:33 PM, Warren <[EMAIL PROTECTED]> wrote: > > I have an app that uses Ibatis and log4j to log Ibatis and java.sql. It > logs > perfectly. I have another app that does not use Ibatis and I can not get > log4j to log java.sql. I know that logging is working and log4j has > initialized logging for java.sql. > > Is Ibatis working with java.sql somehow so that log4j can log SQL > statements, or should you be able to log SQL statement and java.sql > without > Ibatis? > > Thanks, > > Warren > > >
