怎么样配置druid将sql语句及参数记录到日志文件中去？ -数据源报错
"
<a href=""http://my.oschina.net/wenshao"" target=""_blank"" rel=""nofollow"">@wenshao、@逝水fox ，怎么样配置druid将sql语句及参数记录到日志文件中去？下面是我的配置，能否帮忙看下什么原因不能记录到日志中去？
<pre class=""brush:java; toolbar: true; auto-links: false;"">log4j.rootLogger=info,stdout,infologlog4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Threshold=debug log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=<%d{yyyy-MM-dd HHss}> <%p> [%c] - %m%n
log4j.appender.infolog=org.apache.log4j.DailyRollingFileAppender log4j.appender.infolog.File=${catalina.home}/logs/info.log log4j.appender.infolog.DatePattern='.'yyyy-MM-dd'.log' log4j.appender.infolog.ImmediateFlush=true log4j.appender.infolog.Append=true log4j.appender.infolog.Threshold=info log4j.appender.infolog.layout=org.apache.log4j.PatternLayout log4j.appender.infolog.layout.ConversionPattern=<%d{yyyy-MM-dd HHss}> <%p> [%c] - %m%n
Druid
log4j.logger.druid.sql=info,stdout,infolog log4j.logger.druid.sql.DataSource=info,stdout,infolog log4j.logger.druid.sql.Connection=info,stdout,infolog log4j.logger.druid.sql.Statement=info,stdout,infolog log4j.logger.druid.sql.ResultSet=info,stdout,infolog
"
展开
收起
1
条回答
写回答
写回答
-
"@ <a href=""http://my.oschina.net/shishuifox"" rel=""nofollow"">逝水fox######<span style=""font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:14.65625px;background-color:#F8F8F8;"">log4j.logger.druid.sql=debug,stdout,infolog######<div class=""ref"">
引用来自“wenshao”的答案
log4j.logger.druid.sql=debug,stdout,infolog@wenshao ，这样配置后是可以正常显示，但怎么每条信息都会显示2次呢？######怎样的显示两次？############你配置了两个log filter了吧######引用来自“34176470”的答案
引用来自“wenshao”的答案
怎样的显示两次？<2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ... <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ... <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle引用来自“wenshao”的答案
你配置了两个log filter了吧###### @wenshao ，有配置两个 log filter吗？######感觉是配置了两个log filter，你在LogFilter中调试看看，是不是两个LogFilter了。######<!-- 每隔5分钟将监控日志输出到日志文件中，单位是毫秒。 --> <property name="timeBetweenLogStatsMillis" value="300000" /> <!-- 监控数据库 --> <property name="proxyFilters"> <list> <ref bean="stat-filter" /> <ref bean="wall-filter" /> <ref bean="log-filter" /> </list> </property> <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter"> <property name="slowSqlMillis" value="3000" /> <property name="logSlowSql" value="true" /> <property name="mergeSql" value="true" /> </bean> <bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter"> <!-- <property name="resultSetLogEnabled" value="false" /> --> <!-- <property name="statementExecutableSqlLogEnable" value="true" /> --> </bean> <bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter"> <property name="dbType" value="oracle" /> <property name="config" ref="wall-filter-config" /> </bean> <bean id="wall-filter-config" class="com.alibaba.druid.wall.WallConfig" init-method="init"> <property name="dir" value="META-INF/druid/wall/oracle" /> </bean>
可能是这里：
log4j.logger.druid.sql=info,stdout,infolog
导致输出了两次
"2020-05-31 21:36:56赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关问答
问答排行榜
最热
最新
推荐问答
相关文章
相关电子书
更多
