Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 13512 invoked from network); 3 Aug 2005 21:27:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Aug 2005 21:27:16 -0000 Received: (qmail 91341 invoked by uid 500); 3 Aug 2005 21:27:16 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 91030 invoked by uid 500); 3 Aug 2005 21:27:15 -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 91017 invoked by uid 99); 3 Aug 2005 21:27:15 -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 14:27:15 -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 14:27:05 -0700 Received: from wbln0014.worldbank.org (138.220.29.7) by wbapiron02.worldbank.org with ESMTP; 03 Aug 2005 17:27:12 -0400 X-SBRS: None X-IronPort-AV: i="3.95,165,1120449600"; d="scan'208"; a="35230133:sNHT37195944" In-Reply-To: <762ca9ae05080313162af5d9d9@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 17:26:41 -0400 X-MIMETrack: Serialize by Router on WBLN0014/Facility/World Bank(Release 6.5.3FP1|December 15, 2004) at 08/03/2005 05:27:12 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 I am planning for it. do you have a link handy to a complete reference on the upgrade instruc= tions from v1.0 to the latest? I need to evaluate the effort. Vahan Amirbekyan ISG Business Systems The World Bank 1850 I Street, NW, Washington, DC 20433 Tel: 202 / 458-9642 (office) vamirbekyan@worldbank.org = Daniel Henrique = Ferreira e = Silva = To = cc = 08/03/2005 = Subject 05:16 PM Re: SQL logging = = = Please respond = to = user-java@ibati = s.apache.org = = = Hi Vamirberkyan, By the way, why don't you try iBATIS latest version? Version 1.x was cool, but version 2.x is super cool ;-) It has a lot of features that i bet you couldn't live without them after getting introduced to. My 2 cents, Daniel Silva. On 8/3/05, vamirbekyan@worldbank.org wrote:= > thank you Zhongmin! > I was two clicks away from having logs I needed after receiving your = message! > > > > > Zhongmin Chen > gmail.com> 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 he= lp. > > 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,ibatisFi= le > 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 wrot= e: > > 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= to 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= ... > > > > > > > > > > > > > > =