Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 70227 invoked from network); 3 Aug 2005 19:19:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Aug 2005 19:19:42 -0000 Received: (qmail 93320 invoked by uid 500); 3 Aug 2005 19:19:39 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 93304 invoked by uid 500); 3 Aug 2005 19:19:39 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 93291 invoked by uid 99); 3 Aug 2005 19:19:39 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Aug 2005 12:19:39 -0700 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.86.98.58] (HELO wbapiron02.worldbank.org) (192.86.98.58) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Aug 2005 12:19:29 -0700 Received: from wbln0014.worldbank.org (138.220.29.7) by wbapiron02.worldbank.org with ESMTP; 03 Aug 2005 15:18:37 -0400 X-SBRS: None X-IronPort-AV: i="3.95,164,1120449600"; d="scan'208"; a="35213378:sNHT24612424" In-Reply-To: <93d5d9550508031203db948b5@mail.gmail.com> Subject: Re: SQL logging To: user-java@ibatis.apache.org X-Mailer: Lotus Notes 652HF79 October 15, 2004 Message-ID: From: vamirbekyan@worldbank.org Date: Wed, 3 Aug 2005 15:18:05 -0400 X-MIMETrack: Serialize by Router on WBLN0014/Facility/World Bank(Release 6.5.3FP1|December 15, 2004) at 08/03/2005 03:18:36 PM MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N thank you Zhongmin! I was two clicks away from having logs I needed after receiving your me= ssage! = Zhongmin Chen = = To user-java@ibatis.apache.org = 08/03/2005 = cc 03:03 PM = = Subject Re: SQL logging = Please respond = to = user-java@ibati = s.apache.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= ,ibatisFile 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 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 wrote:= > I am using iBatis 1.0 > any clue on to get iBatis1.0 to start logging generated queries? > > I have > com.ibatis=3DDEBUG > in log4j.properties that does not help > > > > > > > TNO > > To > user-java@ibatis.apache.org > 08/03/2005 cc > 07:30 AM > Subject > Re: SQL logging > Please respond > to > user-java@ibati > s.apache.org > > > > > > > Try > > > > > > Eugeny N Dzhurinsky a =E9crit : > > >Is there any way to view the queries the iBATIS generates? I tried t= o set up > >the java.sql=3DDEBUG, in log4j, but no luck for now. > > > > > > > > > -- > Il n'y a pas de mauvais langage, il n'y a que des bons programmeurs..= . > > > > > =