It's often useful when debugging a Grails application to be able to see the exact SQL that is being executed in the database.
If you're using GORM, you can modify your /grails-app/conf/application.yml file with the following settings. Each Hibernate statement that is executed will be outputted to the standard console.
dataSource:
logSql: true
formatSql: true