Spring-Hibernate 日志记录 - 单独的日志文件

发布于 2024-11-29 11:19:48 字数 1060 浏览 1 评论 0原文

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

#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

原文

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

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

誰ツ都不明白 2024-12-06 11:19:48

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

给定记录器的每个启用的记录请求都将
转发到该记录器中的所有附加程序以及附加程序
处于较高的层次结构中。

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

log4j.additivity.jdbc.sqltiming = false

参考：

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.

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)