Can't stop Hibernate from writing log to console (log4j.properties is ok)

Question

I've already set

<property name="show_sql">false</property>

& disable all messages in log4j.properties

But Hibernate shit to console with all queries & statements.

Answer 1

You adding something like this to log4j.properties?

log4j.logger.org.hibernate = WARN

Answer 2

Setting the hibernate.show_sql to true tells hibernate to Write all SQL statements to console. This is an alternative to setting the log category org.hibernate.SQL to debug.

So even if you set this property to false, make sure that you don't have the following category defined (or configured to use a console appender):

log4j.logger.org.hibernate.SQL=DEBUG

Also, make sure that you don't set the hibernate.show_sql programmatically to true when instancing your Configuration object. Hunt something like this:

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

Note that the setProperty(String propertyName, String value) takes as first parameter the full name of a configuration property i.e. hibernate.show_sql, not just show_sql.

Answer 3

It seems very strange, but when Use Eclipse with JUnit Test task, all output still goes to Console (in Eclipse Console window).

But when I use ant command for unit testing, nothing goes to console.