log4jdbc监控sql及执行时间

log4j.rootLogger=debug, CONSOLE,file log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=[%-5p] %d-->%m%n log4j.appender.file=org.apache.log4j.DailyRollingFileAppender log4j.appender.file.File=qhlt.log log4j.appender.file.layout=org.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern=%m%n log4j.logger.java.sql.ResultSet=debug log4j.logger.java.sql.Connection=debug log4j.logger.java.sql.Statement=debug log4j.logger.java.sql.PreparedStatement=debug #log4j.logger.jdbc.audit=INFO,jdbc #log4j.additivity.jdbc.audit=false # ##Log only JDBC calls to ResultSet objects #log4j.logger.jdbc.resultset=INFO,jdbc #log4j.additivity.jdbc.resultset=false # ##Log only the SQL that is executed. #log4j.logger.jdbc.sqlonly=DEBUG,sql #log4j.additivity.jdbc.sqlonly=false # ##Log timing information about the SQL that is executed. #log4j.logger.jdbc.sqltiming=DEBUG,sqltiming #log4j.additivity.jdbc.sqltiming=true # ##Log connection open/close events and connection number dump #log4j.logger.jdbc.connection=FATAL,connection #log4j.additivity.jdbc.connection=false # # ##the appender used for the JDBC API layer call logging above, sql only #log4j.appender.sql=org.apache.log4j.DailyRollingFileAppender #log4j.appender.sql.File=sql.log #log4j.appender.sql.Append=false #log4j.appender.sql.layout=org.apache.log4j.PatternLayout #log4j.appender.sql.layout.ConversionPattern=-----> {yyyy-MM-dd HH:mm:ss.SSS} %n%n #log4j.appender.sql.Threshold = INFO # ##the appender used for the JDBC API layer call logging above, sql timing #log4j.appender.sqltiming=org.apache.log4j.DailyRollingFileAppender #log4j.appender.sqltiming.File=../logs/sqltiming.log #log4j.appender.sqltiming.Append=false #log4j.appender.sqltiming.layout=org.apache.log4j.PatternLayout #log4j.appender.sqltiming.layout.ConversionPattern=%-d{yyyy-MM-dd HH\:mm\:ss}[%5p] %c -->%m%n ##log4j.appender.sqltiming.layout=org.apache.log4j.PatternLayout ##log4j.appender.sqltiming.layout.ConversionPattern=-----> {yyyy-MM-dd HH:mm:ss.SSS} %n%n #log4j.appender.sqltiming.Threshold = INFO # ##the appender used for the JDBC API layer call logging above #log4j.appender.jdbc=org.apache.log4j.DailyRollingFileAppender #log4j.appender.jdbc.File=../logs/jdbc.log #log4j.appender.jdbc.Append=false #log4j.appender.jdbc.layout=org.apache.log4j.PatternLayout #log4j.appender.jdbc.layout.ConversionPattern={yyyy-MM-dd HH:mm:ss.SSS} %n #log4j.appender.jdbc.Threshold = INFO # ##the appender used for the JDBC Connection open and close events #log4j.appender.connection=org.apache.log4j.DailyRollingFileAppender #log4j.appender.connection.File=../logs/connection.log #log4j.appender.connection.Append=false #log4j.appender.connection.layout=org.apache.log4j.PatternLayout #log4j.appender.connection.layout.ConversionPattern={yyyy-MM-dd HH:mm:ss.SSS} %n #log4j.appender.connection.Threshold = INFO # #log4j.additivity.monitor=true #log4j.logger.monitor=INFO,monitor #log4j.appender.monitor=org.apache.log4j.DailyRollingFileAppender #log4j.appender.monitor.File=../logs/monitor.log #log4j.appender.monitor.Append=false #log4j.appender.monitor.layout=org.apache.log4j.PatternLayout #log4j.appender.monitor.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss}[%5p] %c -->%m%n