log4j配置输出hibernate执行的SQL和相应参数以及打印结果

hibernate的配置文件：hibernate.properties中设置：

 

hibernate.show_sql=true
hibernate.format_sql=true
#hibernate.use_sql_comments=true

 

log4j.properties中设置：

<appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
  <param name="Threshold" value="TRACE"/>
  <layout class="org.apache.log4j.PatternLayout">
   <param name="ConversionPattern" value="[%d{yyy-MM-dd HH:mm:ss:SSS}][%p][%t] %30.30c %x: %m%n" />
  </layout>
  <filter class="org.apache.log4j.varia.LevelRangeFilter">
   <param name="LevelMax" value="TRACE" />
   <param name="LevelMin" value="TRACE" />
  </filter>
 </appender>

<logger name="org.hibernate.type.descriptor.sql.BasicBinder">
  <level value="TRACE" />
 </logger>
 <logger name="org.hibernate.type.descriptor.sql.BasicExtractor">
  <level value="TRACE" />
 </logger>
 <logger name="org.hibernate.engine.QueryParameters">
  <level value="TRACE" />
 </logger>
 <logger name="org.hibernate">
  <level value="DEBUG" />
 </logger>
 <logger name="org.hibernate.engine.query.HQLQueryPlan">
  <level value="DEBUG" />
 </logger>
 <root>
   <!-- <appender-ref ref="INFO" />
  <appender-ref ref="DEBUG" /> -->
  <appender-ref ref="STDOUT" />
  <appender-ref ref="ERROR" />
 </root>