spring-ibatis sql log setting

log4j.rootCategory=INFO, consoleLog

 

log4j.category.jp.terasoluna=DEBUG

log4j.category.org.springframework=INFO

log4j.category.org.apache.struts=INFO

 

log4j.category.java.sql.Connection= DEBUG 

log4j.category.java.sql.Statement= DEBUG 

log4j.category.java.sql.PreparedStatement= DEBUG 

log4j.category.java.sql.ResultSet= DEBUG 

log4j.category.com.ibatis=DEBUG

 

log4j.appender.consoleLog=org.apache.log4j.ConsoleAppender

log4j.appender.consoleLog.Target=System.out

log4j.appender.consoleLog.layout=org.apache.log4j.PatternLayout

log4j.appender.consoleLog.layout.ConversionPattern=[%d{yyyy/MM/dd HH:mm:ss}][%p][%c{1}] %m%n