Grails dumping SQL statements

Edit the DataSource.groovy

dataSource {
   dbCreate = ...
   url = ...
   ...
   logSql = true
}

And in the Config.groovy:

log4j = {
   ...
   debug 'org.hibernate.SQL'
   trace 'org.hibernate.type'
}