log4j configuration (print MyBatis SQL, output to file) 1

Log4j.rootlogger=info,console,file

Log4j.appender.stdout = Org.apache.log4j.ConsoleAppender
Log4j.appender.stdout.Target = System.out
Log4j.appender.stdout.layout = Org.apache.log4j.PatternLayout
Log4j.appender.stdout.layout.ConversionPattern =%d{absolute}%5p%c{1}:%l-%m%n
#Console
Log4j.appender.console=org.apache.log4j.consoleappender
Log4j.appender.console.layout=org.apache.log4j.patternlayout
log4j.appender.console.layout.conversionpattern=%d [%t]%-5p [%c]-%m%n
Log4j.logger.java.sql.resultset=info
Log4j.logger.org.apache=info
#FILE
Log4j.appender.file=org.apache.log4j.rollingfileappender
Log4j.appender.file.append=true
#log4j. appender.file.file=. /logs/share.log
Log4j.appender.file.file=d:/logs/share3.log
Log4j.appender.file.threshold=info
Log4j.appender.file.layout=org.apache.log4j.patternlayout
Log4j.appender.file.layout.conversionpattern=%d{yyyy-mm-dd HH:MM:SS} [%5p]-%c-%f (%l)-%m%n
log4j.appender.file.maxfilesize=10mb
#ibatis Logger Config
Log4j.logger.com.ibatis=debug
Log4j.logger.com.ibatis.common.jdbc.simpledatasource=debug
Log4j.logger.com.ibatis.common.jdbc.scriptrunner=debug
Log4j.logger.com.ibatis.sqlmap.engine.impl.sqlmapclientdelegate=debug
Log4j.logger.java.sql.connection=debug
Log4j.logger.java.sql.statement=debug
Log4j.logger.java.sql.preparedstatement=debug,stdout

has been verified to see MyBatis sql to change log bounds to debug

log4j configuration (print MyBatis SQL, output to file) 1