Hibernate : Enable Logging of the SQL Statements

Define a seperate appender

         name="SQL" class="org.apache.log4j.DailyRollingFileAppender">
                 name="File" value="c:/logs/sql.log" />
                 name="Append" value="false" />
                 name="Threshold" value="TRACE" />
                 name="DatePattern" value="'.'yyyy-MM-dd" />
                 class="org.apache.log4j.PatternLayout">
                         name="ConversionPattern" value="%d{ISO8601} %-5p [%c] %m%n" />
                
        

define the log categories

         name="org.hibernate.type">
                 value="TRACE" />
                 ref="SQL"/>
        
         name="org.hibernate.SQL">
                 value="TRACE" />
                 ref="SQL"/>