* 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  결과들이 모두 로그에 기록된다..

}}}