iBATIS logs almost everything to java.sql logs. The only thing you'll see in com.ibatis is caching information. Sounds like you've got it working.
Jeff Butler On 8/31/07, Gilles Schlienger <[EMAIL PROTECTED]> wrote: > > Tried that but still no luck. > > java.sql logs work fine though > > But still nothing with com.ibatis.etc... > > Don't know what to try... > > Regards > Gilles > > ----- Message d'origine ---- > De : Brandon Goodin <[EMAIL PROTECTED]> > À : user-java@ibatis.apache.org > Envoyé le : Vendredi, 31 Août 2007, 16h29mn 44s > Objet : Re: Re : Re : Log4j again... sorry > > Additionally you could try adding commons-logging to your webapp classpath > and then place the following contents into a WEB-INF/commons- > logging.properties file: > > org.apache.commons.logging.Log=org.apache.commons.logging.impl.Log4JLogger > > Brandon > > On 8/31/07, Brandon Goodin <[EMAIL PROTECTED]> wrote: > > > > Make sure you have log4j in your webapp classpath and then add the > > following to your log4j.properties file in the root of your > > WEB-INF/classes directory. > > > > # Rules reminder: > > # DEBUG < INFO < WARN < ERROR < FATAL > > > > # Global logging configuration > > log4j.rootLogger=WARN, stdout > > > > # SqlMap logging configuration... > > log4j.logger.com.ibatis=DEBUG > > log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG > > log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG > > log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG > > log4j.logger.java.sql=DEBUG > > log4j.logger.java.sql.Connection=DEBUG > > log4j.logger.java.sql.Statement=DEBUG > > log4j.logger.java.sql.PreparedStatement=DEBUG > > log4j.logger.java.sql.ResultSet=DEBUG > > > > log4j.logger.com.auxilium.web=DEBUG > > > > ## Console output... > > log4j.appender.stdout=org.apache.log4j.ConsoleAppender > > log4j.appender.stdout.layout=org.apache.log4j.PatternLayout > > log4j.appender.stdout.layout.ConversionPattern=%5p %d %C.%M(): %m%n > > > > Brandon > > > > On 8/31/07, Gilles Schlienger < [EMAIL PROTECTED]> wrote: > > > > > > Something weird: > > > I created a servlet listener, and added it in my web.xml file. > > > > > > In this listener I call: > > > com.ibatis.common.logging.LogFactory.selectLog4JLogging(); > > > > > > Still I get no log in the console or anywhere else... > > > I use Ibatis with Spring using Spring's Template. > > > > > > Regards > > > Gilles > > > > > > ----- Message d'origine ---- > > > De : Gilles Schlienger <[EMAIL PROTECTED] > > > > À : user-java@ibatis.apache.org > > > Envoyé le : Vendredi, 31 Août 2007, 16h10mn 12s > > > Objet : Re : Log4j again... sorry > > > > > > Thanks for your email, > > > > > > Still no luck though... > > > No log happens. > > > But I can see the SQL request in my MYSQL database logs... > > > > > > Regards > > > Gilles > > > > > > ----- Message d'origine ---- > > > De : Larry Meadors <[EMAIL PROTECTED] > > > > À : user-java@ibatis.apache.org > > > Envoyé le : Vendredi, 31 Août 2007, 15h09mn 37s > > > Objet : Re: Log4j again... sorry > > > > > > Try this: > > > > > > log4j.logger.java.sql=DEBUG > > > > > > Larry > > > > > > > > > On 8/31/07, Gilles Schlienger < [EMAIL PROTECTED]> wrote: > > > > Hi everyone, > > > > > > > > Sorry to bother you with that subject again, but I can not get any > > > log, wether from ibatis or from the java.sql BUT I do have spring logs > > > and logs from my webapp code... My code uses commons-logging AND log4j (I > > > use a log4j.properties file) > > > > > > > > I have read the documentation and I think I understand the > > > dependency of iBatis with commons-logging... > > > > > > > > My webapp uses Tomcat 5.5.23 and iBatis 2.3 > > > > > > > > I have in my webapp : > > > > - in WEB-INF/lib: commons-loggingXX.jar and log4j-XX.jar > > > > - in WEB-INF/classes: log4j.properties > > > > with lines: > > > > log4j.rootLogger=INFO, stdout > > > > > > > > log4j.appender.stdout=org.apache.log4j.ConsoleAppender > > > > log4j.appender.stdout.layout=org.apache.log4j.PatternLayout > > > > log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - <%m>%n > > > > ... > > > > ###### Logging configuration for IBATIS ###### > > > > # SqlMap logging configuration... > > > > log4j.logger.com.ibatis=DEBUG > > > > log4j.logger.java.sql.PreparedStatement=DEBUG > > > > > > > > I do get my webapp personnal code logs, but I get nothing for ibatis > > > and java.sql... > > > > > > > > In Tomcat 5.5.23 by default, there is no jar about logging in > > > common/lib but in the /bin directory there is a > > > commons-logging-api.jar > > > > > > > > Could somebody help me please? That would be really appreciated > > > > Thanks a lot in advance > > > > Regards > > > > Gilles > > > > > > > > > > > > > > > > > > > > > > > > > > > _____________________________________________________________________________ > > > > Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers > > > Yahoo! Mail > > > > > > > > > > > > > > > > > > > > > > > > > > > > _____________________________________________________________________________ > > > Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers > > > Yahoo! Mail > > > > > > > > > > > > > > > > > > > > > > > > _____________________________________________________________________________ > > > Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers > > > Yahoo! Mail > > > > > > > > > > > ------------------------------ > Ne gardez plus qu'une seule adresse mail ! Copiez vos > mails<http://www.trueswitch.com/yahoo-fr/>vers Yahoo! Mail >
