<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j">
   ...
   <logger name="org.hibernate.SQL"><level value="DEBUG"/></logger>
   <logger name="org.hibernate.type"><level value="TRACE"/></logger>
   ...
 </log4j:configuration>