Printing out SQL statements in Play (part 2)

This is a follow up to my original post on printing sql statements in Play. The method I described earlier no longer works with Play 2.2.X.

I’ve found a simpler method that currently works with Play 2.1.X and Play 2.2.X.

Just go and edit your application.conf file and add the following lines.

db.default.logStatements=true
logger.com.jolbox=DEBUG

Restart your application and you should see something like the following in your logs.

[debug] c.j.b.PreparedStatementHandle - select t0.uuid as c0, t0.email as c1, t0.creation_time as c2, t0.expiration_time as c3, t0.is_sign_up as c4 from persistable_token t0