ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Lamey <cla...@localmatters.com>
Subject Re: Ibatis java.sql and log4j
Date Fri, 30 Nov 2007 23:20:20 GMT
>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" <warren@clarksnutrition.com> 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:jeffgbutler@gmail.com]
>   Sent: Friday, November 30, 2007 1:42 PM
>   To: user-java@ibatis.apache.org
>   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 <warren@clarksnutrition.com> 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

View raw message