본문 바로가기

프로그래밍/MYSQL

spring에서 ibatis사용시 콘솔에 log 찍기

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration PUBLIC "-//APACHE//DTD LOG4J 1.2//EN" "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

 <!-- Appenders -->
 <appender name="console" class="org.apache.log4j.ConsoleAppender">
  <param name="Target" value="System.out" />
  <layout class="org.apache.log4j.PatternLayout">
   <param name="ConversionPattern" value="%-5p: %c - %m%n" />
  </layout>
 </appender>
 
 <appender name="sql" class="org.apache.log4j.ConsoleAppender">
     <layout class="org.apache.log4j.PatternLayour">
         <param name="ConversionPattern" value="%d [%t] %-5 %c - %m%n" />
     </layout>
     <filter class="org.aparche.log4j.varia.StringMatchFilter">
         <param name="StringToMatch" value="Result" />
         <param name="AcceptOnMatch" value="false" />
     </filter>
 </appender>
 
 <!-- Application Loggers -->
 <logger name="com.ck.fishing">
  <level value="info" />
 </logger>
 
 <!-- 3rdparty Loggers -->
 <logger name="org.springframework.core">
  <level value="info" />
 </logger>
 
 <logger name="org.springframework.beans">
  <level value="info" />
 </logger>
 
 <logger name="org.springframework.context">
  <level value="info" />
 </logger>

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

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

    <logger name="java.sql">
        <level value="DEBUG" />
    </logger>
    
 <!-- Root Logger -->
 <root>
  <priority value="warn" />
  <appender-ref ref="console" />
 </root>
 
</log4j:configuration>