Ibatis prints the SQL statement-log4j

Jar package

Log4j-1.2.11.jar

Log4j configuration file

Log4j. Properties

# For JBoss: Avoid to setup log4j outside $ jboss_home/Server/default/deploy/log4j. xml!
# For all other servers: comment out the log4j listener in Web. XML to activate log4j.
Log4j. rootlogger = info, stdout, logfile

Log4j. appender. stdout = org. Apache. log4j. leleappender
Log4j. appender. stdout. layout = org. Apache. log4j. patternlayout
Log4j. appender. stdout. layout. conversionpattern = % d % P [% C]-% m % N

Log4j. appender. logfile = org. Apache. log4j. rollingfileappender
Log4j. appender. logfile. File = mpsmodel. Log
Log4j. appender. logfile. maxfilesize = 512kb
# Keep three backup files.
Log4j. appender. logfile. maxbackupindex = 3
# Pattern to output: date priority [category]-message
Log4j. appender. logfile. layout = org. Apache. log4j. patternlayout
Log4j. appender. logfile. layout. conversionpattern = % d % P [% C]-% m % N

# Log4j.category.org. Apache. commons. DBCP = debug
# Log4j.category.com. ibatis = debug
# Log4j.category.org. springframework = debug

# Kai write
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, fileout
Log4j. Logger. java. SQL. resultset = debug