搭建Hibernate日志-log4jdbc
官方: https://code.google.com/p/log4jdbc/
log4jdbc分析sql性能 http://hongliangpan.iteye.com/blog/1088398
xml配置方法： log4jdbc日志框架介绍 http://blog.sina.com.cn/s/blog_57769b7b0101m1il.html
http://xiaominghimi.blog.51cto.com/2614927/969781
log4j不能使用1.2.15版本,否则丢失包,浪费时间
启动程序改为:
jdbc.driver=net.sf.log4jdbc.DriverSpy
jdbc.url=jdbc:log4jdbc:sqlserver//localhost:1433;DatabaseName=Test
在jdbc和sqlserver之间加上log4jdbc，就变成了jdbc:log4jdbc:sqlserver
比如mysql就应该写成: jdbc:log4jdbc:mysql://localhost:3306/jbpmtest
Easy to configure, in most cases all you need to do is change the driver class name to net.sf.log4jdbc.DriverSpy and prepend “jdbc:log4” to your existing jdbc url, set up your logging categories and you’re ready to go!
log4j.properties
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
log4j.rootLogger=warn, stdout ### direct log messages to stdout ### 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 # log4jdbc log4j.logger.jdbc.sqlonly=INFO log4j.logger.jdbc.sqltiming=INFO log4j.logger.jdbc.audit=OFF log4j.logger.jdbc.resultset=OFF log4j.logger.jdbc.connection=OFF |
两种配置参考
log4j.xml
log4j.properties
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
!============================================================================== ! log4j.properties - An example configuration properties file for log4j. ! ! Logging levels are: ! DEBUG < INFO < WARN < ERROR < FATAL !============================================================================== ! turn on the internal log4j debugging flag so we can see what it is doing log4j.debug=true !============================================================================== ! JDBC API layer call logging : ! INFO shows logging, DEBUG also shows where in code the jdbc calls were made, ! setting DEBUG to true might cause minor slow-down in some environments. ! If you experience too much slowness, use INFO instead. ! Log all JDBC calls except for ResultSet calls 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=false ! 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.FileAppender log4j.appender.sql.File=./logs/sql.log log4j.appender.sql.Append=false log4j.appender.sql.layout=org.apache.log4j.PatternLayout log4j.appender.sql.layout.ConversionPattern=-----> %d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n ! the appender used for the JDBC API layer call logging above, sql timing log4j.appender.sqltiming=org.apache.log4j.FileAppender 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.SSS} %m%n%n ! the appender used for the JDBC API layer call logging above log4j.appender.jdbc=org.apache.log4j.FileAppender 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=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n ! the appender used for the JDBC Connection open and close events log4j.appender.connection=org.apache.log4j.FileAppender 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=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n |
