@wenshao、@逝水fox ,怎么样配置druid将sql语句及参数记录到日志文件中去?下面是我的配置,能否帮忙看下什么原因不能记录到日志中去?
log4j.rootLogger=info,stdout,infolog log4j.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 HH����ss}> <%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 HH����ss}> <%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
@ 逝水fox######log4j.logger.druid.sql=debug,stdout,infolog######
<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
<!-- 每隔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
导致输出了两次
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。