nutz mysql druid_Druid-慢SQL日志记录 在nutz里datasource如何配置

谢谢^^ 做这种配置之后 info_slowsql.log输出来的日志无sql,请问一下是什么原因导致的?

log4j的配置如下:

log4j.rootLogger = info,stdout,D,nutz,warn,A1,A2

\u8F93\u51FA\u5230\u63A7\u5236\u53F0

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 [%t] %p %c - %m %n

\u8F93\u51FA\u5230\u65E5\u5FD7\u6587\u4EF6

log4j.appender.debug = org.apache.log4j.DailyRollingFileAppender

log4j.appender.debug.File = ${catalina.home}/logs/mk-eam-debug.log

log4j.appender.debug.datePattern=yyyy-MM-dd'.log'

log4j.appender.debug.Append = true

\u8F93\u51FADEBUG\u7EA7\u522B\u4EE5\u4E0A\u7684\u65E5\u5FD7

log4j.appender.debug.Threshold = INFO

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

log4j.appender.debug.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss,SSS} [ %t:%r ] - [ %p ] %m%n

\u4FDD\u5B58\u5F02\u5E38\u4FE1\u606F\u5230\u5355\u72EC\u6587\u4EF6

log4j.appender.D = org.apache.log4j.DailyRollingFileAppender

\u5F02\u5E38\u65E5\u5FD7\u6587\u4EF6\u540D

log4j.appender.D.File = ${catalina.home}/logs/mk-eam-error.log

log4j.appender.D.datePattern=yyyy-MM-dd'.log'

log4j.appender.D.Append = true

\u53EA\u8F93\u51FAERROR\u7EA7\u522B\u4EE5\u4E0A\u7684\u65E5\u5FD7!!!

log4j.appender.D.Threshold = ERROR

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

log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss,SSS} [%X{username}] [ %t:%r ] - [ %p ] %m%n

nutz\u65E5\u5FD7\u6587\u4EF6

log4j.appender.nutz = org.apache.log4j.DailyRollingFileAppender

log4j.appender.nutz.File = ${catalina.home}/logs/nutz.log

log4j.appender.nutz.append = true

log4j.appender.nutz.encoding=UTF-8

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

log4j.appender.nutz.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss,SSS} [%X{username}] [ %t:%r ] - [ %p ] %m%n

nutz log info controller

log4j.category.org.nutz=debug

log4j.category.org.nutz.dao=debug

log4j.category.org.nutz.ioc=debug

log4j.category.org.nutz.mvc=debug

Druid

log4j.logger.druid.sql=info,A1,A2

log4j.logger.druid.sql.DataSource=info,A1,A2

log4j.logger.druid.sql.Connection=info,A1,A2

log4j.logger.druid.sql.Statement=info,A1,A2

log4j.logger.druid.sql.ResultSet=info,A1,A2

log4j.appender.A1=org.apache.log4j.DailyRollingFileAppender

log4j.appender.A1.File=${catalina.home}/info_slowsql.log

log4j.appender.A1.DatePattern='.'yyyy-MM-dd

log4j.appender.A1.File=${catalina.home}/logs/info_slowsql.log

log4j.appender.A1.File=${WebApp.TomcatHome}/logs/info_slowsql.log

log4j.appender.A1.ImmediateFlush=true

log4j.appender.A1.Append=true

log4j.appender.A1.Threshold=info

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

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

log4j.appender.A2=org.apache.log4j.DailyRollingFileAppender

log4j.appender.A2.File=${catalina.home}/warn_slowsql.log

log4j.appender.A2.DatePattern='.'yyyy-MM-dd

log4j.appender.A2.File=${catalina.home}/logs/warn_slowsql.log

log4j.appender.A2.File=${WebApp.TomcatHome}/logs/warn_slowsql.log

log4j.appender.A2.ImmediateFlush=true

log4j.appender.A2.Append=true

log4j.appender.A2.Threshold=warn

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

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值