[log4j] log4j 에서 ibatis 쿼리로그 남기는 방법

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

  <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
    <layout class="org.apache.log4j.PatternLayout">
      <param name="ConversionPattern"
          value="%p - %C{1}.%M(%L) | %m%n"/>
    </layout>
    <filter class="org.apache.log4j.varia.StringMatchFilter">
      <param name="StringToMatch" value="Result" />
      <param name="AcceptOnMatch" value="false" />
    </filter>
  </appender>

  <logger name="org.apache">
    <level value="WARN"/>
  </logger>

  <logger name="org.springframework">
    <level value="DEBUG"/>
  </logger>

  <logger name="com.ibatis">
    <level value="DEBUG"/>
  </logger>

  <logger name="java.sql">
    <level value="DEBUG"/>
  </logger>

  <logger name="woosin78.spring">
    <level value="DEBUG"/>
  </logger>

  <logger name="com.WARN">
    <level value="DEBUG"/>
  </logger>

  <root>
    <level value="WARN"/>
    <appender-ref ref="CONSOLE"/>
  </root>

</log4j:configuration>