[Apache iBATIS Wiki] Updated: How do I get SqlMapClient to log SQL statements?

[ib...@incubator.apache.org]

   Date: 2005-01-05T13:43:50
   Editor: NathanMaves
   Wiki: Apache iBATIS Wiki
   Page: How do I get SqlMapClient to log SQL statements?
   URL: http://wiki.apache.org/ibatis/How do I get SqlMapClient to log SQL statements?

   no comment

Change Log:

------------------------------------------------------------------------------
@@ -7,3 +7,36 @@
 log4j.logger.java.sql=DEBUG
 
 If you set your default log level to DEBUG, that will work, too...but you will get debug level logging for everything in the world. 
+
+Here is another example of how to configure ibatis with log4j using an xml config file.
+{{{
+<?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>
+}}}