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, or do I miss something?
make sure:
db.default.logStatements=true
This config is actually a setting of bonecp which is connection pool used in play2
Add a custom logger configuration to conf/logger.xml
.
The content may be:
<configuration>
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%-5level - %msg%n</pattern>
</encoder>
</appender>
<logger name="com.jolbox.bonecp" level="DEBUG">
<appender-ref ref="STDOUT" />
</logger>
<logger name="play" level="DEBUG">
<appender-ref ref="STDOUT" />
</logger>
<logger name="application" level="DEBUG">
<appender-ref ref="STDOUT" />
</logger>
</configuration>
The com.jlbox.bonecp
is for bonecp
, and play
and application
are for play2.
Comment the logger settings in application.conf
:
# Logger
# ~~~~~
# You can also configure logback (http://logback.qos.ch/), by providing a logger.xml file in the conf directory .
# Root logger:
# logger.root=ERROR
# Logger used by the framework:
# logger.play=INFO
# Logger provided to your application:
# logger.application=DEBUG
Restart play, and you will see all executed SQLs(including parameter values).