turn off hibernate logging in eclipse

Question

I have a spring mvc app running in eclipse with hibernate and slf4j. I would like to turn off hibernate logging in the console because it is burying other console messages that I want to be able to see. How can I turn off hibernate logging?

I have done a number of web searches on this topic, and looked at other postings on stack overflow, but the other postings do not answer my question. For example, the following code from another posting will not compile in eclipse because it gives messages that the methods are not part of the objects, even when I import every possible set of packages for the given object:

    List<Logger> loggers = Collections.<Logger>list(LogManager.getCurrentLoggers());
    loggers.add(LogManager.getRootLogger());
    for ( Logger logger : loggers ) {
        logger.setLevel(Level.OFF);
    }

Also, doing a key word search in my workspace for show_sql produced no results, so it seems that I cannot just set hibernate.show_sql to false.

Perhaps the other solutions are for outdated versions of the libraries? I am using eclipse kepler, slf4 1.7.5 and hibernate 4.2.

score 2 · Answer 1 · answered Apr 01 '14 at 14:58

2

In order to turn off the hibernate messages you have to properly configure your logging framework.

Most probably you're using log4j. Configuration of log4j is located either in log4j.xml or log4j.properties

just add something similar to this to the configuration file

log4j.logger.org.hibernate=ERROR

answered Apr 01 '14 at 14:58

WeMakeSoftware

9,039
5
34
52

try ctrl+shift+t and type log4j – WeMakeSoftware Apr 01 '14 at 15:03
upload the project to any service, I can take a look at it – WeMakeSoftware Apr 01 '14 at 15:16
try searching outside Eclipse with OS searching tools. Might be that Eclipse cannot find the file specified. – WeMakeSoftware Apr 01 '14 at 15:37
dunno :( the question is not that specific, so it's hard to give the definite answer without the actual source code – WeMakeSoftware Apr 01 '14 at 15:57
+1 for trying to help. Someone else ultimately posted the silver bullet. – CodeMed Apr 01 '14 at 21:03

score 2 · Accepted Answer · answered Apr 01 '14 at 20:09

2

If you just want to turn off Hibernate SQL logging in Spring's Petclinic sample application, set jpa.showSql to false in src/main/resources/spring/data-access.properties.

Hope this helps.

answered Apr 01 '14 at 20:09

Shinichi Kai

4,415
2
21
25

+1 and credit for the answer. Thank you for pointing out what should have been obvious to me, but was not. – CodeMed Apr 01 '14 at 21:02

score 0 · Answer 3 · edited May 23 '17 at 10:26

0

This might help, setting "show_sql" to false dynamically in your code.

Configuration cfg = new Configuration().configure().
    .setProperty("hibernate.show_sql", "false");

If not check this post on stackoverflow:

Click here

edited May 23 '17 at 10:26

Community

1
1

answered Apr 01 '14 at 15:01

Susie

5,038
10
53
74

it won't work, as you're just creating a new instance of configuration, but you're not using it. Depending on how the user initializes Hibernate it might be a configuration parameter in config file, or a datasource property – WeMakeSoftware Apr 01 '14 at 15:06
Use org.hibernate.cfg – Susie Apr 01 '14 at 15:09
Check if you have a bean definition for a session factory – Susie Apr 01 '14 at 15:23
@Susie +1 for trying to help. Someone else ultimately posted the silver bullet. – CodeMed Apr 01 '14 at 21:04

turn off hibernate logging in eclipse

3 Answers3