title: Grails print Hibernate debug log in test case
body: <p>May I know how can I print out <strong>Hibernate</strong> debug log in <strong>Grails</strong> test case running. </p>
  
  <p>I have configured in <code>DataSource.groovy</code> </p>
  
  <pre><code>dataSource {
      ...
      logSql = true 
  }
  
  environments {
   ... 
      test {
          dataSource {
             dbCreate = "none"
             url = "jdbc:mysql://localhost/church?useUnicode=yes&amp;characterEncoding=UTF-8"
          logSql = true
           }
       hibernate {
         show_sql = true
           }
       }
   ...
  }
  </code></pre>
  
  <p>and using logger to write log in test case and the controller classes, but I can't see the corresponding <code>Hibernate</code> debug log in test case console. </p>
  
  <p>Please advice. Thanks !</p>