Play Framework 2.0 and Ebean SQL logging

logging playframework-2.0 ebean
Tommi picture Tommi · Mar 15, 2012 · Viewed 11.3k times · Source

I want to examine what SQL statements are generated by Ebean to find out why certain exceptions (related to SQL syntax) are occurring in my Play 2.0 application. Is there a way to log the SQL statements generated by Ebean in Play Framework 2.0?

In Play 1.x, there is a jpa.debugSQL config option, which if set to true, will do exactly this. Does a similar setting for Ebean exist for Play 2.0? The documentation page about Ebean of Play 2.0 is still a bit scarce.

What I have tried so far:

I have added these method calls in my controllers and the onStart / onRequest methods of the Global object, but it doesn't have any effect:

Ebean.getServer(null).getAdminLogging().setLogLevel(LogLevel.SQL);
Ebean.getServer(null).getAdminLogging().setDebugGeneratedSql(Play.isDev());

I have modified the log levels from application.conf, but it didn't help either (even with log level TRACE).

Answer

mbseid picture mbseid · Aug 14, 2012

Sorry to be late to the party, but I use this in development:

db.default.logStatements=true

logger.com.jolbox=DEBUG

Add those two lines to the application.conf and you are good to go.

It outputs all the sql statements. Hope it helps.

Related questions

Logging options for Slick

I'm createing a Play 2.1 app, in which I have decided to use Slick for database interaction. However I can't find documentation about how to configure/enable logging for Slick. Anyone knows this?

Read More
Where to see the logged sql statements in play2?

I found there is such a configuration in application.conf: # If enabled, log SQL statements being executed. db.default.logStatements=true I've enabled it, but I can't find any log file which logged executed sqls. Where can I find it, …

Read More
grep a file, but show several surrounding lines?

I would like to grep for a string, but also show the preceding five lines and the following five lines as well as the matched line. How would I be able to do this?

Read More