| 1 | |
---|
| 2 | * http://luvbaby.tistory.com/152 |
---|
| 3 | {{{ |
---|
| 4 | #---------- file logging ---------- |
---|
| 5 | log4j.rootLogger=INFO, rolling |
---|
| 6 | #---------- consol logging ----------- |
---|
| 7 | #log4j.rootLogger=INFO, stdout |
---|
| 8 | #---------- file, console logging ----------- |
---|
| 9 | log4j.logger.java.sql=DEBUG # <-- 이부분이 이바티스 를 sql 구문을 출력 iBatis와 연동한다. log4j.xml |
---|
| 10 | #log4j.rootLogger=INFO, stdout, rolling |
---|
| 11 | log4j.appender.stdout=org.apache.log4j.ConsoleAppender |
---|
| 12 | log4j.appender.stdout.layout=org.apache.log4j.PatternLayout |
---|
| 13 | log4j.appender.stdout.layout.ConversionPattern=[%d] %-5p at %C{3}.%M(%13F:%L) %3x - %m%n |
---|
| 14 | log4j.appender.rolling=org.apache.log4j.DailyRollingFileAppender |
---|
| 15 | log4j.appender.rolling.File=\var\log\passcart\passcart.log |
---|
| 16 | log4j.appender.rolling.Append=true |
---|
| 17 | #---------- every day renew ------------ |
---|
| 18 | log4j.appender.rolling.DatePattern='.'yyyy-MM-dd |
---|
| 19 | #---------- every month renew ------------ |
---|
| 20 | #log4j.appender.rolling.DatePattern='.'yyyy-MM |
---|
| 21 | #---------- every week renew ------------ |
---|
| 22 | #log4j.appender.rolling.DatePattern='.'yyyy-MM-ww |
---|
| 23 | #---------- every 12hours renew ------------- |
---|
| 24 | #log4j.appender.rolling.DatePattern='.'yyyy-MM-dd-a |
---|
| 25 | #---------- every hour renew -------------- |
---|
| 26 | #log4j.appender.rolling.DatePattern='.'yyyy-MM-dd-HH |
---|
| 27 | #---------- every min renew -------------- |
---|
| 28 | #log4j.appender.rolling.DatePattern='.'yyyy-MM-dd-HH-mm |
---|
| 29 | log4j.appender.rolling.layout=org.apache.log4j.PatternLayout |
---|
| 30 | log4j.appender.rolling.layout.ConversionPattern=[%d] %-5p at %C{3}.%M(%13F:%L) %3x - %m%n |
---|
| 31 | }}} |
---|
| 32 | {{{ |
---|
| 33 | <?xml version="1.0" encoding="UTF-8" ?> |
---|
| 34 | <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"> |
---|
| 35 | |
---|
| 36 | <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"> |
---|
| 37 | |
---|
| 38 | <!-- Console output --> |
---|
| 39 | <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"> |
---|
| 40 | <layout class="org.apache.log4j.PatternLayout"> |
---|
| 41 | <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss} %m (%F:%L) \n"/> |
---|
| 42 | </layout> |
---|
| 43 | </appender> |
---|
| 44 | |
---|
| 45 | <category name="com.ibatis"> |
---|
| 46 | <priority value="debug" /> |
---|
| 47 | </category> |
---|
| 48 | |
---|
| 49 | <category name="java.sql"> |
---|
| 50 | <priority value="debug" /> |
---|
| 51 | </category> |
---|
| 52 | |
---|
| 53 | <!--The root category defines the top level of appenders all catagories inherit --> |
---|
| 54 | |
---|
| 55 | <root> |
---|
| 56 | <priority value ="error" /> |
---|
| 57 | <appender-ref ref="STDOUT" /> |
---|
| 58 | </root> |
---|
| 59 | </log4j:configuration> |
---|
| 60 | }}} |
---|
| 61 | |
---|
| 62 | * http://tstudio.tistory.com/15 |
---|
| 63 | {{{ |
---|
| 64 | <appender name="sql" class="org.apache.log4j.ConsoleAppender"> |
---|
| 65 | <layout class="org.apache.log4j.PatternLayout"> |
---|
| 66 | <param name="ConversionPattern" |
---|
| 67 | value="%d [%t] %-5p %c{1} - %m%n" /> |
---|
| 68 | </layout> |
---|
| 69 | |
---|
| 70 | <filter class="org.apache.log4j.varia.StringMatchFilter"> |
---|
| 71 | <param name="StringToMatch" value="Result" /> |
---|
| 72 | <param name="AcceptOnMatch" value="false" /> |
---|
| 73 | </filter> |
---|
| 74 | </appender> |
---|
| 75 | |
---|
| 76 | <category name="com.ibatis"> |
---|
| 77 | <priority value="debug" /> |
---|
| 78 | </category> |
---|
| 79 | |
---|
| 80 | <category name="java.sql"> |
---|
| 81 | <priority value="debug" /> |
---|
| 82 | <appender-ref ref="sql" /> |
---|
| 83 | </category> |
---|
| 84 | |
---|
| 85 | |
---|
| 86 | 특이한 점은 ibatis 쿼리로그를 남길때 로그에 ResultSet 이 모두 기록되기 때문에 |
---|
| 87 | 이부분을 필터링하기 위해 굵은글씨 부분이 추가되었다. |
---|
| 88 | 굵은부분이 없다면 ResultSet 결과들이 모두 로그에 기록된다.. |
---|
| 89 | |
---|
| 90 | }}} |