How to exclude hibernate output from log

Question

My output contains a lot of rows as Hibernate: select salary0_.id as id1_15_19_, salary0_.balance as balance2_15_19_, salary0_.bonus as bonus3_15_19_.....

How to exclude them? My log4j.xml is:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration debug="true"
                 xmlns:log4j='http://jakarta.apache.org/log4j/'>

<appender name="console" class="org.apache.log4j.ConsoleAppender">
    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern"
               value="%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n" />
    </layout>
</appender>

<root>
    <level value="INFO" />
    <appender-ref ref="console" />
</root>

</log4j:configuration>

Sampisa · Accepted Answer · 2016-05-02 14:35:02Z

4

It is not related to your log4j configuration, but to Hibernate configuration. Somewhere you should have a property "showsql" set to true.

E.g. if you use e.g. Spring and a root-context.xml file you could have something like

    <property name="jpaVendorAdapter">
        <bean
            class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
            <property name="showSql" value="true" />
           <!-- [snip] -->
        </bean>
    </property>

Alternatively, on hibernate.xml you can add:

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

answered May 2, 2016 at 14:35

Sampisa

1,5932 gold badges21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

v.ladynev Over a year ago

It can be in hibernate.properties too. The full name of the property hibernate.show_sql

Collectives™ on Stack Overflow

How to exclude hibernate output from log

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related