log4j无法关闭hibernate日志

最新推荐文章于 2021-07-21 11:08:31 发布

engineer_qi

最新推荐文章于 2021-07-21 11:08:31 发布

阅读量897

点赞数

分类专栏： java基础文章标签： log4j hibernate关闭日志

本文链接：https://blog.csdn.net/engineer_qi/article/details/84713860

版权

java基础专栏收录该内容

10 篇文章 0 订阅

订阅专栏

在项目中遇到大量hibernate日志导致困扰，尝试修改log4j.properties和log4j.xml文件的级别为INFO，但依然出现DEBUG日志。最后发现一个不起眼的jar包内含有log4j.xml，调整其配置后成功关闭DEBUG日志。通过设置hibernate.show_sql为false和调整log4j的appender-ref也能有效管理hibernate日志。

摘要由CSDN通过智能技术生成

最近部署了一个项目，发现debug日志特别多，打开发现很多都是hibernate里面的日志，很郁闷。查阅了好多资料发现，log4j的日志一般是有一个有限级别的，就是说项目首先会优先使用log4j.xml里面的配置，如果没有log4j.xml文件，那么它会去src下面去找log4j.properties文件里面的配置。我引用的底层框架里面有log4j.xml，我改成了info级别的，项目里面log4j.properties文件也改成了info级别了发现还是有debug日志。找了好久，发现引用了公司的一个不起眼的jar包，里面有个log4j.xml,改掉里面的级别，问题解决。

<props>

<prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>

<prop key="hibernate.show_sql">false</prop>//改成false

<prop key="hibernate.format_sql">false</prop>

<prop key="hibernate.connection.release_mode">after_statement</prop>

</props>

</property>

1.我的log4j.properties配置文件

#############################################################################

# Licensed to the Apache Software Foundation (ASF) under one or more

# contributor license agreements. See the NOTICE file distributed with

# this work for additional information regarding copyright ownership.

# The ASF licenses this file to You under the Apache License, Version 2.0

# (the "License"); you may not use this file except in compliance with

# the License. You may obtain a copy of the License at

# http://www.apache.org/licenses/LICENSE-2.0

# Unless required by applicable law or agreed to in writing, software

# distributed under the License is distributed on an "AS IS" BASIS,

# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

# See the License for the specific language governing permissions and

# limitations under the License.

#############################################################################

# Please don't modify the log level until we reach to acceptable test coverage.

# It's very useful when I test examples manually.

log4j.rootCategory=INFO, stdout

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

#log4j.appender.stdout.layout.ConversionPattern=[%d{HH:mm:ss}] %p [%c] - %m%n

# you could use this pattern to test the MDC with the Chat server

log4j.appender.stdout.layout.ConversionPattern=[%d{HH:mm:ss}] %t %p %X{name} [%X{user}] [%X{remoteAddress}] [%c] - %m%n

2.log4j.xml文件配置

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<log4j:configuration debug="false" xmlns:log4j="http://jakarta.apache.org/log4j/">

</layout>

</filter>

</appender>

</layout>

</filter>

</appender>

</layout>

</filter>

</appender>

</layout>

</filter>

</appender>

<!-- <appender name="hibernate_console" class="org.apache.log4j.ConsoleAppender"> <param name="Target" value="System.out" /> <param name="ImmediateFlush" value="true" /> <layout class="org.apache.log4j.PatternLayout">

</appender>

<appender-ref ref="HibernateLoggerMonitor" />

</logger>

<root>

<appender-ref ref="framework_console" />

<appender-ref ref="framework_debug" /> //干掉这个，debug日志就没了。。。

<appender-ref ref="framework_info" />

<appender-ref ref="framework_error" />

</root>

</category>