Spring-Hibernate日志记录-单独的日志文件 [英] Spring-Hibernate logging - separate log files

问题描述

我正在使用Spring&在我的应用程序中休眠后，我想设置两个不同的日志文件-一个主日志文件所有非sql日志记录，另一个用于编写sql查询的文件.这是我的log4j.properties文件.但是当sql日志文件按预期方式工作时.问题是主日志文件还包含sql查询.我应该在此处进行哪些更改以停止将sql查询写入主日志文件.

I am using Spring & Hibernate in my application and I want to set up two different log files - one main log file all the non-sql logging and another file for writing sql queries. This is my log4j.properties file.. But while the sql log file is working as expected..the issue is that the main log file also contains sql queries.. What changes should I make here to to stop writing sql queries to main log file..

#application log properties
log4j.appender.rollingFile = org.apache.log4j.DailyRollingFileAppender
log4j.appender.rollingFile.File = C:\\myapp\\logs\\app.log
log4j.appender.rollingFile.Threshold = TRACE
log4j.appender.rollingFile.DatePattern = '.'yyyy-MM-dd
log4j.appender.rollingFile.layout = org.apache.log4j.PatternLayout 
log4j.appender.rollingFile.layout.ConversionPattern=%d %5p [%C:%M:%L] - %m%n
log4j.rootLogger = ERROR, rollingFile

#hibernate properties
log4j.appender.file = org.apache.log4j.DailyRollingFileAppender 
log4j.appender.file.File = C:\\myapp\\logs\\sql.log
log4j.appender.file.Threshold = TRACE
log4j.appender.file.DatePattern = '.'yyyy-MM-dd
log4j.appender.file.layout = org.apache.log4j.PatternLayout 
log4j.appender.file.layout.ConversionPattern=%d %5p [%C:%M:%L] - %m%n
log4j.logger.jdbc.sqltiming = DEBUG, file

推荐答案

这是log4j中附加程序的可加行为.

This is the additivity behaviour of the appenders in log4j .

给定记录器的每个启用的记录请求将为转发给该记录器中的所有附加程序以及附加程序在层次结构中更高.

Each enabled logging request for a given logger will be forwarded to all the appenders in that logger as well as the appenders higher in the hierarchy.

只需将记录器 jdbc.sqltiming 的可加性设置为false，其日志消息就不会传播到其父记录器的附加程序(即app.log)

Just set the additivity for the logger jdbc.sqltiming to false and its log messages will not be propagated to its parent loggers' appenders (i.e. app.log)

log4j.additivity.jdbc.sqltiming = false

---

参考:

有关Appender的更多信息，请参见 Appenders和Layouts 部分可加性

See the section Appenders and Layouts for more information about Appender Additivity

这篇关于Spring-Hibernate日志记录-单独的日志文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！