Logging hibernate query not working

Question

I want lo log hibernate generated sql queries using logback logging framework, but problem is that it is generating log file but not logging anything related to hibernate.

This is how logback.xml looks like

<appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>${Project_HOME}\\module\\logs\\module.log</file>
        <append>true</append>
        <rollingPolicy     class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <fileNamePattern>${Project_HOME}\\module\\logs\\module_%d{yyyy-    MM-dd}.%i.log.zip
            </fileNamePattern>
            <maxHistory>10</maxHistory>
            <timeBasedFileNamingAndTriggeringPolicy
                class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
                <maxFileSize>10KB</maxFileSize>

            </timeBasedFileNamingAndTriggeringPolicy>
        </rollingPolicy>
        <encoder>
            <pattern>%date %-5level [%file:%line] - %msg%n
            </pattern>
        </encoder>
    </appender>
<logger name="org.hibernate.SQL">
        <level value="DEBUG" />
        <appender-ref ref="FILE" />
    </logger>

Also all other logging using same appender is working fine.

Sainatha Reddy Rajanala · Accepted Answer · 2012-12-20 07:11:19Z

2

I would suggest you to add a property in hibernate-cfg.xml

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

Hope this will help you .

answered Dec 20, 2012 at 7:11

Sainatha Reddy Rajanala

2921 gold badge3 silver badges13 bronze badges

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

1 Comment

Matt D. Over a year ago

Show_sql will always log to System.out()

Hoàng Long · Accepted Answer · 2012-12-20 07:19:28Z

1

I would recommend you change your logger config a little:

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

answered Dec 20, 2012 at 7:19

Hoàng Long

10.9k21 gold badges81 silver badges128 bronze badges

2 Comments

Hoàng Long Over a year ago

@jaishukla: It should work, specially if it works for your other classes. Could you please upload a part of the log file?

Hoàng Long Over a year ago

@jaishukla: are you sure that you're calling hibernate from your code?

Collectives™ on Stack Overflow

Logging hibernate query not working

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related