哪里可以看到play2中记录的sql语句？-Wheretoseetheloggedsqlstatementsinplay2?

56  

1. application.conf

make sure:

确保：

db.default.logStatements=true

This config is actually a setting of bonecp which is connection pool used in play2

此配置实际上是bonecp的设置，它是play2中使用的连接池

2. custom logger

Add a custom logger configuration to conf/logger.xml.

将自定义记录器配置添加到conf / logger.xml。

The content may be:

内容可能是：

    
        
            %-5level - %msg%n
        
    

    
        
    

    
        
    

    
        
    

The com.jlbox.bonecp is for bonecp, and play and application are for play2.

com.jlbox.bonecp用于bonecp，play和application用于play2。

3. disable logger settings in application.conf

Comment the logger settings in application.conf:

在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).

重新开始播放，您将看到所有已执行的SQL（包括参数值）。

5  

This no longer works in Play 2.4.2 from what I can tell. The default connection pool engine was changed over to HikariCP.

根据我的判断，这在Play 2.4.2中不再有效。默认连接池引擎已更改为HikariCP。

Add this to your application.conf and follow the directions below. Things should work:

将其添加到您的application.conf并按照以下说明操作。事应该奏效：

Application.conf

Application.conf

db.default.pool = "bonecp"
db.default.bonecp.logStatements=true

conf/logger.xml Add a custom logger configuration to conf/logger.xml.

conf / logger.xml将自定义记录器配置添加到conf / logger.xml。

    
        
            %-5level - %msg%n
        
    

    
        
    

    
        
    

    
        
    

3  

Just add the following to application.conf (works for me in play 2.2.1)

只需将以下内容添加到application.conf（适用于我的游戏2.2.1）

db.default.logStatements=true

logger.com.jolbox.bOnecp=DEBUG

1  

For HikariCP (i.e. starting with Play 2.4), see https://github.com/brettwooldridge/HikariCP/wiki/JDBC-Logging:

对于HikariCP（即从Play 2.4开始），请参阅https://github.com/brettwooldridge/HikariCP/wiki/JDBC-Logging：

HikariCP does not inherently include JDBC logging at this time. This is a conscious decision, not an oversight or undeveloped future roadmap item. Nearly all major database have a JDBC driver capable of logging on its own. For those that do not, log4jdbc-log4j2 is a good option.

HikariCP目前并不包含JDBC日志记录。这是一个有意识的决定，而不是未来的监督或未开发的路线图项目。几乎所有主要数据库都有一个能够自行登录的JDBC驱动程序。对于那些没有的人，log4jdbc-log4j2是一个不错的选择。

This wiki page documents how to enable logging for common databases, as well as log4jdbc-log4j2.

此Wiki页面记录了如何为常见数据库以及log4jdbc-log4j2启用日志记录。

For log4jdbc-log4j2: add "org.bgee.log4jdbc-log4j2" % "log4jdbc-log4j2-jdbc4.1" % "1.16" to libraryDependencies; configuration is described at https://code.google.com/archive/p/log4jdbc-log4j2/.

对于log4jdbc-log4j2：将“org.bgee.log4jdbc-log4j2”％“log4jdbc-log4j2-jdbc4.1”％“1.16”添加到libraryDependencies;有关配置，请参阅https://code.google.com/archive/p/log4jdbc-log4j2/。