• http://luvbaby.tistory.com/152

  #---------- file logging ----------
  log4j.rootLogger=INFO, rolling
  #---------- consol logging -----------
  #log4j.rootLogger=INFO, stdout
  #---------- file, console logging -----------
  log4j.logger.java.sql=DEBUG               # <-- 이부분이 이바티스 를 sql 구문을 출력 iBatis와 연동한다. log4j.xml
  #log4j.rootLogger=INFO, stdout, rolling
  log4j.appender.stdout=org.apache.log4j.ConsoleAppender
  log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
  log4j.appender.stdout.layout.ConversionPattern=[%d] %-5p  at %C{3}.%M(%13F:%L) %3x - %m%n
  log4j.appender.rolling=org.apache.log4j.DailyRollingFileAppender
  log4j.appender.rolling.File=\var\log\passcart\passcart.log
  log4j.appender.rolling.Append=true
  #---------- every day renew ------------
  log4j.appender.rolling.DatePattern='.'yyyy-MM-dd
  #---------- every month renew ------------
  #log4j.appender.rolling.DatePattern='.'yyyy-MM
  #---------- every week renew ------------
  #log4j.appender.rolling.DatePattern='.'yyyy-MM-ww
  #---------- every 12hours renew -------------
  #log4j.appender.rolling.DatePattern='.'yyyy-MM-dd-a
  #---------- every hour renew --------------
  #log4j.appender.rolling.DatePattern='.'yyyy-MM-dd-HH
  #---------- every min renew --------------
  #log4j.appender.rolling.DatePattern='.'yyyy-MM-dd-HH-mm
  log4j.appender.rolling.layout=org.apache.log4j.PatternLayout
  log4j.appender.rolling.layout.ConversionPattern=[%d] %-5p  at %C{3}.%M(%13F:%L) %3x - %m%n
  

  <?xml version="1.0" encoding="UTF-8" ?>
  <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
  
  <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
  
          <!-- Console output -->
          <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
              <layout class="org.apache.log4j.PatternLayout">
                      <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss} %m  (%F:%L) \n"/>
              </layout>
          </appender>
  
          <category name="com.ibatis">
                  <priority value="debug" />
          </category>
  
          <category name="java.sql">
                  <priority value="debug" />
          </category>
  
          <!--The root category defines the top level of appenders all catagories inherit -->
  
          <root>
                  <priority value ="error" />
                  <appender-ref ref="STDOUT" />
          </root>
  </log4j:configuration>
  

• http://tstudio.tistory.com/15

  <appender name="sql" class="org.apache.log4j.ConsoleAppender">
    <layout class="org.apache.log4j.PatternLayout">
     <param name="ConversionPattern"
      value="%d [%t] %-5p %c{1} - %m%n" />
    </layout>
   
            <filter class="org.apache.log4j.varia.StringMatchFilter"> 
                    <param name="StringToMatch" value="Result" /> 
                    <param name="AcceptOnMatch" value="false" /> 
            </filter> 
   </appender>
  
   <category name="com.ibatis">
    <priority value="debug" />
   </category>
   
   <category name="java.sql">
    <priority value="debug" />
    <appender-ref ref="sql" />
   </category>
  
  
  특이한 점은 ibatis 쿼리로그를 남길때 로그에 ResultSet  이 모두 기록되기 때문에
  이부분을 필터링하기 위해 굵은글씨 부분이 추가되었다.
  굵은부분이 없다면 ResultSet  결과들이 모두 로그에 기록된다..