How to log SQL statements in Grails

sql logging grails
user2427 picture user2427 · Apr 2, 2010 · Viewed 54.7k times · Source

I want to log in the console or in a file, all the queries that Grails does, to check performance.

I had configured this without success.

Any idea would help.

Answer

Tomislav Nakic-Alfirevic picture Tomislav Nakic-Alfirevic · Apr 2, 2010

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.

Related questions

How can I log the generated SQL from DbContext.SaveChanges() in my Program?

According this thread, we can log the generated SQL via EF, but what about DbContext.SaveChanges()? Is there any easy way to do this job without any extra frameworks?

Read More
Log the actual SQL query using ActiveRecord with Yii2?

I'm doing this: $students = Student::find()->all(); return $this->render('process', array('students' => $students)); and then this in the view: foreach($students as $student) { echo $student->name . ',  '; echo $student->getQuizActivitiesCount(); ?&…

Read More
cakephp see the compiled SQL Query before execution

My query gets the timeout error on each run. Its a pagination with joins. I want to debug the SQL, but since I get a timeout, I can't see it. How can I see the compiled SQL Query before execution? …

Read More