How to log SQL statements in Grails

by

Setting

datasource {
...
logSql = true
}

in DataSource.groovy (as per these instructions) was enough to get it working in my environment. It seems that parts of the FAQ are out of date (e.g. the many-to-many columns backwards question) so this might also be something that changed in the meantime.

More Related Contents:

  1. Logging ALL Queries on a SQL Server 2008 Express Database?
  2. How to deal with SQL column names that look like SQL keywords?
  3. Why isn’t SQL ANSI-92 standard better adopted over ANSI-89?
  4. Generating a range of numbers in MySQL
  5. Truncate (not round) decimal places in SQL Server
  6. Getting list of tables, and fields in each, in a database
  7. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  8. Dynamic Pivot Columns in SQL Server
  9. Selecting data into a Postgres array
  10. How to run a stored procedure in sql server every hour?
  11. How do I see active SQL Server connections?
  12. How to pivot rows into columns (custom pivoting)
  13. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  14. Calculate the number of records for each date between 2 dates
  15. What is causing Foreign Key Mismatch error?
  16. T-SQL: How to use parameters in dynamic SQL?
  17. MySQL – how to front pad zip code with “0”?
  18. How to compare datetime with only date in SQL Server
  19. SQL server select distinct rows using most recent value only
  20. How can I implement SQL INTERSECT and MINUS operations in MS Access
  21. Split words with a capital letter in sql
  22. Access 2010: Syntax error (missing operator) in query expression
  23. Generate random int value from 3 to 6
  24. scope_identity vs ident_current
  25. PostgreSQL 9.3: Dynamic pivot table
  26. How to create a Date in SQL Server given the Day, Month and Year as Integers
  27. Count records for every month in a year
  28. What is the best way to implement soft deletion?
  29. Postgres: convert single row to multiple rows (unpivot)
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment