问题记录---打印ibatis日志

用ibatis搭了一个测试用的小项目，却发现打印不出日志信息。网上找了好多.properties形式的配置文件，也是不好用。最后从别的项目里找了一个log4j.xml形式的配置文件，放到src目录下，终于好用了。

<?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] %d{yyyy-MM-dd HH:mm:ss} %l: %m%n" />
		</layout>
	</appender>

	<appender name="rootLogger" class="org.apache.log4j.DailyRollingFileAppender">
		<param name="File" value="../logs/rootLogger.log" />
		<param name="Append" value="true" />
		<param name="DatePattern" value="'.'yyyy-MM-dd" />
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="[%p] %d{yyyy-MM-dd HH:mm:ss} %l: %m%n" />
		</layout>
	</appender>

	<logger name="com.ibatis" additivity="true">
		<level value="debug" />
	</logger>

	<logger name="java.sql.Connection" additivity="true">
		<level value="debug" />
	</logger>

	<logger name="java.sql.Statement" additivity="true">
		<level value="debug" />
	</logger>
	
	<logger name="java.sql.PreparedStatement" additivity="true">
		<level value="DEBUG" />
	</logger>
	
	<logger name="java.sql.ResultSet" additivity="true">
		<level value="DEBUG" />
	</logger>
	
	<root>
		<level value="info" />
		<appender-ref ref="console" />
		<appender-ref ref="rootLogger" />
	</root>
</log4j:configuration>