java 禁用 HikariPool 日志记录

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/27274115/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-11-02 11:32:10  来源:igfitidea点击:

Disable HikariPool logging

javalogginghikaricp

提问by siphiuel

This is perhaps a very simple question. How do i disable Hikari-CP debug logs? In my log file i have lots of these messages

这或许是一个非常简单的问题。如何禁用 Hikari-CP 调试日志?在我的日志文件中,我有很多这样的消息

DEBUG [.zaxxer.hikari.pool.HikariPool:] - Before cleanup pool stats HikariPool-0 (total=10, inUse=0, avail=10, waiting=0)
DEBUG [.zaxxer.hikari.pool.HikariPool:] - After cleanup pool stats HikariPool-0 (total=10, inUse=0, avail=10, waiting=0)

and in my log4jConfig.xml:

在我的 log4jConfig.xml 中:

<logger name="org.zaxxer.hikari">
    <level value="error"/>
</logger>

Can someone please tell me what is wrong with the logger configuration?

有人可以告诉我记录器配置有什么问题吗?

Thanks!

谢谢!

回答by brettw

The logger name should be com.zaxxer.hikarinot org.zaxxer.hikari.

logger的名称应该是com.zaxxer.hikari没有org.zaxxer.hikari

回答by c5soft

The class name is displaying in you DEBUG info: DEBUG [.zaxxer.hikari.pool.HikariPool:] - ... here the class name is zaxxer.hikari.pool.HikariPool, Just modify config file as being disaplayed.

类名显示在您的 DEBUG 信息中:DEBUG [.zaxxer.hikari.pool.HikariPool:] - ... 这里的类名是 zaxxer.hikari.pool.HikariPool,只需将配置文件修改为显示即可。

I use logback logger, there is a file named logback.xml located in resources folder, to disable HikariPool logging, i write following config:

我使用 logback 记录器,资源文件夹中有一个名为 logback.xml 的文件,用于禁用 HikariPool 日志记录,我编写以下配置:

 <configuration>
...
    <logger name="com.zaxxer.hikari.pool.PoolBase" level="ERROR"/>
    <logger name="com.zaxxer.hikari.pool.HikariPool" level="ERROR"/>
    <logger name="com.zaxxer.hikari.HikariDataSource" level="ERROR"/>
</configuration>

回答by szezso

I use log4j properties, simple add these two lines:

我使用 log4j 属性,简单添加这两行:

log4j.category.com.zaxxer.hikari=INFO
log4j.logger.HikariPool=INFO

回答by Amir Fo

You can set the levels of Hikari loggers dynamically:

您可以动态设置 Hikari 记录器的级别:

import org.apache.log4j.Logger;
import org.apache.log4j.Level;

public class App{
     public static main(String[] args) {
         Logger.getLogger("com.zaxxer.hikari.pool.PoolBase").setLevel(Level.OFF);
         Logger.getLogger("com.zaxxer.hikari.pool.HikariPool").setLevel(Level.OFF);
         Logger.getLogger("com.zaxxer.hikari.HikariDataSource").setLevel(Level.OFF);
         Logger.getLogger("com.zaxxer.hikari.HikariConfig").setLevel(Level.OFF);
         Logger.getLogger("com.zaxxer.hikari.util.DriverDataSource").setLevel(Level.OFF);
     }
}

I have tested this on hikariCP 3.4.1 with log4j 1.2.17

我已经用 log4j 1.2.17 在 hikariCP 3.4.1 上测试过了