You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Rusty Wright <ru...@gmail.com> on 2007/09/04 09:28:02 UTC
Re: Re : Re : Re : Re : Log4j again... sorry
I don't know if this is what is affecting you but I find the log4j
properties file format confusing and error prone so I use the xml
format. Here is my log4j.xml file:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "http://logging.apache.org/log4j/docs/api/org/apache/log4j/xml/log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<!-- param entries must come before layout entry -->
<appender name="FILE" class="org.apache.log4j.RollingFileAppender">
<param
name="File"
value="/tmp/my-app.log"
/>
<param
name="MaxFileSize"
value="2000kb"
/>
<param
name="MaxBackupIndex"
value="9"
/>
<layout class="org.apache.log4j.PatternLayout">
<param
name="ConversionPattern"
value="%p: %d [%C %M] %m%n"
/>
</layout>
</appender>
<appender name="CONS" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param
name="ConversionPattern"
value="%p: %C.%M: %m%n"
/>
</layout>
</appender>
<!-- example of how to change the level and appender -->
<!-- for a specific class. -->
<logger name="com.ibatis">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.common.jdbc.SimpleDataSource">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.sqlmap.engine.cache.CacheModel">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.sqlmap.engine.impl.SqlMapClientImpl">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.sqlmap.engine.builder.xml.SqlMapParser">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.common.util.StopWatch">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.Connection">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.Statement">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.PreparedStatement">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.ResultSet">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<!-- example of how to change the level and appender -->
<!-- for a specific class. -->
<logger name="org.springframework">
<level value="warn" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<root>
<level
value="warn"
/>
<appender-ref
ref="CONS"
/>
<appender-ref
ref="FILE"
/>
</root>
</log4j:configuration>
And in my web.xml I have
<context-param>
<param-name>
log4jConfigLocation
</param-name>
<param-value>
/WEB-INF/log4j.xml
</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.util.Log4jConfigListener
</listener-class>
</listener>
Gilles Schlienger wrote:
> Thanks Jeff
> Gilles
>
> ----- Message d'origine ----
> De : Jeff Butler <je...@gmail.com>
> À : user-java@ibatis.apache.org
> Envoyé le : Vendredi, 31 Août 2007, 17h41mn 19s
> Objet : Re: Re : Re : Re : Log4j again... sorry
>
> 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* <s_gilou@yahoo.com
> <ma...@yahoo.com>> 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 < brandon.goodin@gmail.com
> <ma...@gmail.com>>
> À : user-java@ibatis.apache.org <ma...@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* < brandon.goodin@gmail.com
> <ma...@gmail.com>> 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* < s_gilou@yahoo.com
> <ma...@yahoo.com>> 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 <s_gilou@yahoo.com
> <ma...@yahoo.com> >
> À : user-java@ibatis.apache.org
> <ma...@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 <lmeadors@apache.org
> <ma...@apache.org> >
> À : user-java@ibatis.apache.org
> <ma...@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 < s_gilou@yahoo.com
> <ma...@yahoo.com>> 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
>
>
>
>
> ------------------------------------------------------------------------
> Ne gardez plus qu'une seule adresse mail ! Copiez vos mails
> <http://www.trueswitch.com/yahoo-fr/> vers Yahoo! Mail
Re: Re : Re : Re : Re : Log4j again... sorry
Posted by Rusty Wright <ru...@gmail.com>.
I don't know if this is what is affecting you but I find the log4j
properties file format confusing and error prone so I use the xml
format. Here is my log4j.xml file:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "http://logging.apache.org/log4j/docs/api/org/apache/log4j/xml/log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
<!-- param entries must come before layout entry -->
<appender name="FILE" class="org.apache.log4j.RollingFileAppender">
<param
name="File"
value="/tmp/my-app.log"
/>
<param
name="MaxFileSize"
value="2000kb"
/>
<param
name="MaxBackupIndex"
value="9"
/>
<layout class="org.apache.log4j.PatternLayout">
<param
name="ConversionPattern"
value="%p: %d [%C %M] %m%n"
/>
</layout>
</appender>
<appender name="CONS" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param
name="ConversionPattern"
value="%p: %C.%M: %m%n"
/>
</layout>
</appender>
<!-- example of how to change the level and appender -->
<!-- for a specific class. -->
<logger name="com.ibatis">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.common.jdbc.SimpleDataSource">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.sqlmap.engine.cache.CacheModel">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.sqlmap.engine.impl.SqlMapClientImpl">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.sqlmap.engine.builder.xml.SqlMapParser">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="com.ibatis.common.util.StopWatch">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.Connection">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.Statement">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.PreparedStatement">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<logger name="java.sql.ResultSet">
<level value="debug" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<!-- example of how to change the level and appender -->
<!-- for a specific class. -->
<logger name="org.springframework">
<level value="warn" />
<appender-ref ref="CONS" />
<appender-ref ref="FILE" />
</logger>
<root>
<level
value="warn"
/>
<appender-ref
ref="CONS"
/>
<appender-ref
ref="FILE"
/>
</root>
</log4j:configuration>
And in my web.xml I have
<context-param>
<param-name>
log4jConfigLocation
</param-name>
<param-value>
/WEB-INF/log4j.xml
</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.util.Log4jConfigListener
</listener-class>
</listener>
Gilles Schlienger wrote:
> Thanks Jeff
> Gilles
>
> ----- Message d'origine ----
> De : Jeff Butler <je...@gmail.com>
> À : user-java@ibatis.apache.org
> Envoyé le : Vendredi, 31 Août 2007, 17h41mn 19s
> Objet : Re: Re : Re : Re : Log4j again... sorry
>
> 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* <s_gilou@yahoo.com
> <ma...@yahoo.com>> 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 < brandon.goodin@gmail.com
> <ma...@gmail.com>>
> À : user-java@ibatis.apache.org <ma...@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* < brandon.goodin@gmail.com
> <ma...@gmail.com>> 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* < s_gilou@yahoo.com
> <ma...@yahoo.com>> 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 <s_gilou@yahoo.com
> <ma...@yahoo.com> >
> À : user-java@ibatis.apache.org
> <ma...@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 <lmeadors@apache.org
> <ma...@apache.org> >
> À : user-java@ibatis.apache.org
> <ma...@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 < s_gilou@yahoo.com
> <ma...@yahoo.com>> 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
>
>
>
>
> ------------------------------------------------------------------------
> Ne gardez plus qu'une seule adresse mail ! Copiez vos mails
> <http://www.trueswitch.com/yahoo-fr/> vers Yahoo! Mail