Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of zhongmin.chen@gmail.com
 designates 64.233.184.194 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=gY9KkbZWbvnLclZHj6Y15jBdi2BrCO2k4kfanc9vBGSZ3Tp7GArMUabjp85o3pX/1nlUMdMcsZiZarFw6UWBzCcfg80XTwaxoFYFLLylNjDYwsNbwntTbaCqW5UaL4rNeGosKI//mG1Mxzj3YcJk6c3Nqd/Et1dgrA0xJG7IRO0=
Message-ID: <93d5d9550508031203db948b5@mail.gmail.com>
Date: Wed, 3 Aug 2005 12:03:43 -0700
From: Zhongmin Chen <zhongmin.chen@gmail.com>
Reply-To: Zhongmin Chen <zhongmin.chen@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: SQL logging
In-Reply-To: 
 <OF0C840B0F.FBF736AB-ON85257052.00661926-85257052.00669465@worldbank.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <42F0AAF0.1010609@free.fr>
	 <OF0C840B0F.FBF736AB-ON85257052.00661926-85257052.00669465@worldbank.org>

Hi,

Having something similar to the following in log4j.properties will help.

Regards,
Zhongmin

# Global logging configuration
log4j.rootLogger=3Derror,stdout
# log4j.rootLogger=3Ddebug,ibatisFile

# Console output...
log4j.appender.stdout=3Dorg.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=3Dorg.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=3D%5p [%t] - %m%n

########### for ibatis
# SqlMap logging configuration...
log4j.logger.com.ibatis=3DDEBUG,ibatisFile
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=3DDEBUG,ibatisFile
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=3DDEBUG,ibatisFile
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=3DDEBUG,iba=
tisFile
log4j.logger.java.sql.Connection=3DDEBUG,ibatisFile
log4j.logger.java.sql.Statement=3DDEBUG,ibatisFile
log4j.logger.java.sql.PreparedStatement=3DDEBUG,ibatisFile
log4j.logger.java.sql.ResultSet=3DDEBUG,ibatisFile

log4j.appender.ibatisFile=3Dorg.apache.log4j.RollingFileAppender
log4j.appender.ibatisFile.MaxFileSize=3D6MB
log4j.appender.ibatisFile.immediateFlush=3Dtrue
log4j.appender.ibatisFile.MaxBackupIndex=3D3
log4j.appender.ibatisFile.File=3D<log file full path>
log4j.appender.ibatisFile.Threshold=3DDEBUG
log4j.appender.ibatisFile.append=3Dtrue
log4j.appender.ibatisFile.layout=3Dorg.apache.log4j.PatternLayout
log4j.appender.ibatisFile.layout.ConversionPattern=3D%d{DATE} %c{3} %p - %m=
%n


On 8/3/05, vamirbekyan@worldbank.org <vamirbekyan@worldbank.org> wrote:
> I am using iBatis 1.0
> any clue on to get iBatis1.0 to start logging generated queries?
>=20
> I have
> com.ibatis=3DDEBUG
> in log4j.properties that does not help
>=20
>=20
>=20
>=20
>=20
>=20
>              TNO
>              <tnodev@free.fr
>              >                                                           =
    To
>                                      user-java@ibatis.apache.org
>              08/03/2005                                                  =
    cc
>              07:30 AM
>                                                                         S=
ubject
>                                      Re: SQL logging
>              Please respond
>                    to
>              user-java@ibati
>               s.apache.org
>=20
>=20
>=20
>=20
>=20
>=20
> Try
> <category name=3D"com.ibatis">
> <priority value=3D"debug" />
> </category>
>=20
>=20
> Eugeny N Dzhurinsky a =E9crit :
>=20
> >Is there any way to view the queries the iBATIS generates? I tried to se=
t up
> >the java.sql=3DDEBUG, in log4j, but no luck for now.
> >
> >
> >
>=20
>=20
> --
> Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs...
>=20
>=20
>=20
>=20
>