Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Logging SQL statements
Date: Fri, 23 Mar 2007 08:04:17 -0400
Message-ID: <F3DF3F1DBD6ABB42AA45DA6D3F9B88F10333206B@us-atl-mx03.infor.com>
In-Reply-To: <9632994.post@talk.nabble.com>
Thread-Topic: Logging SQL statements
Thread-Index: AcdtP5h+Q/xyWRWkRGebB690RolYJAAA0Mhw
References: <9632495.post@talk.nabble.com>
 <F3DF3F1DBD6ABB42AA45DA6D3F9B88F103332034@us-atl-mx03.infor.com>
 <9632994.post@talk.nabble.com>
From: "Murtaza Goga" <Murtaza.Goga@trisyngroup.com>
To: <user-java@ibatis.apache.org>

It would. =20
You could extend the FileAppender in Log4J and filter out the selects.
Not as elegant but it would work.

-----Original Message-----
From: K1RUHA [mailto:kiryl_kazakevich@yahoo.com]=20
Sent: Friday, March 23, 2007 7:37 AM
To: user-java@ibatis.apache.org
Subject: RE: Logging SQL statements


But this approach will also generate log messages for SELECT statements.
I
was thinking about getting sql statements in DAO and then log them
depending
on configuration parameter.


Goga, Murtaza wrote:
>=20
> If you are using Log4J, you can add an appender and route the logged
sql
> activity from iBatis into a separate file.  The category I believe is
> "java.sql."=20
>=20
> =20
>=20
> ________________________________
>=20
> From: K1RUHA [mailto:kiryl_kazakevich@yahoo.com]=20
> Sent: Friday, March 23, 2007 6:59 AM
> To: user-java@ibatis.apache.org
> Subject: Logging SQL statements
>=20
> =20
>=20
> Hello. I'd like to use iBATIS in our project, but I have one
requierent,
> that I don't know if it supports. I need to log SQL statements that
> modify database (UPDATE and DELETE) into separate file. So I need some
> approach to get these statements in my Java code. Would you mind tell
me
> if iBATIS can do this? Thanx, Kiryl=20
>=20
> ________________________________
>=20
> View this message in context: Logging SQL statements
> <http://www.nabble.com/Logging-SQL-statements-tf3453072.html#a9632495>

> Sent from the iBATIS - User - Java mailing list archive
> <http://www.nabble.com/iBATIS---User---Java-f370.html>  at Nabble.com.
>=20
>=20
>=20

--=20
View this message in context:
http://www.nabble.com/Logging-SQL-statements-tf3453072.html#a9632994
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.