关闭休眠日志到控制台 [英] Turn off hibernate logging to console

问题描述

  Hibernate：select securityus0_.ID在运行Spring / Hibernate应用程序时，我在控制台上看到以下不需要的输出：
 .... 
 Hibernate：选择securityus0_.ID .... 
 Hibernate：选择securityus0_.ID .... 
 Hibernate：选择securityus0_.ID .... 
  

我已经配置了我的Log4j记录器，如下所示：

 < logger name =org.hibernate> 
< level value =FATAL/> 
< / logger> 
 
< category name =STDOUT> 
< priority value =WARN/> 
< / category> 
< category name =STDERR> 
< priority value =WARN/> 
< / category> 
 
 <！ -   - 所有其他记录仪只记录信息及以上记录信息 - > 
< root> 
< priority value =WARN/> 
< appender-ref ref =STDOUT/> 
< / root> 
  

我如何使这些信息无声？

解决方案

我相当肯定你会看到这些SQL语句，因为你的Hibernate配置中的某个地方的属性hibernate.show_sql设置为true。找到该设置并更改为false。

When running my Spring/Hibernate application I see the following unwanted output on the console:

Hibernate: select securityus0_.ID ....
Hibernate: select securityus0_.ID ....
Hibernate: select securityus0_.ID ....
Hibernate: select securityus0_.ID ....

I have configured my Log4j logger like so:

   <logger name="org.hibernate">
     <level value="FATAL"/>
   </logger>

   <category name="STDOUT">
      <priority value="WARN"/>
   </category>
   <category name="STDERR">
      <priority value="WARN"/>
   </category>   

   <!-- for all other loggers log only info and above log messages -->
   <root>
      <priority value="WARN"/> 
      <appender-ref ref="STDOUT" /> 
   </root>

How do I silence these messages?

解决方案

I'm fairly certain that you're seeing those SQL statements because somewhere in your Hibernate config the property "hibernate.show_sql" is set to true. Find that setting and change to false.

这篇关于关闭休眠日志到控制台的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！