Currently, to display the SQL request logs the TRACE level must be enabled in SonarQube. This is hardly convenient as all TRACE logs of any part of code is enabled as well which creates a lot of noise and makes the performance impact even worse.
To fix this :
- property sonar.log.level.web.sql and sonar.log.level.ce.sql are added and allow to control SQL log level for Web and CE JVMs
- logger of SQL request is changed to "sql"
- log level of SQL request stays TRACE
The level of the most accurate and defined property among sonar.log.level and sonar.log.level.web (or sonar.log.level.ce depending on the JVM) must be applied.