hibernate logback sql

Question

I want to see the actual parameters of my SQL queries when I use Hibernate. I add this to my logback.xml to see the queries (with question marks):

<logger name="org.hibernate.type" level="TRACE" />

but to no effect.

Is there any special configuration necessary?

OnConsoleStatusListener shows me the correct configuration

23:48:15,246 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.hibernate.type] to TRACE

but no output from org.hibernate.type package.

I'm using Spring with Jpa.

Answer 1

Things you have to make sure:

1. Are you sure that SLF4J + LogBack is working in your app?
2. Is your logger pointing to any appender?

Answer 2

Have you configured an appended?

<configuration>
  <appender name="FILE" class="ch.qos.logback.core.FileAppender">
    <!-- "application-name" is a variable -->
    <File>c:/logs/${application-name}.log</File>
    <layout class="ch.qos.logback.classic.PatternLayout">
      <Pattern>%d %p %t %c - %m%n</Pattern>
    </layout>
  </appender>
  <root level="debug">
    <appender-ref ref="FILE"/>
  </root>
</configuration>