From 5be796e6040e5608a70e4dd53dadedd1dfd6ff76 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Fri, 13 Jan 2012 17:09:40 +0100
Subject: SONAR-2959 add example to enable SQL logs on server-side

---
 .../src/main/assembly/conf/logback.xml             | 31 ++++++++++++++--------
 1 file changed, 20 insertions(+), 11 deletions(-)

(limited to 'sonar-application/src')

diff --git a/sonar-application/src/main/assembly/conf/logback.xml b/sonar-application/src/main/assembly/conf/logback.xml
index 7a2efd3b369..a380678fc9d 100644
--- a/sonar-application/src/main/assembly/conf/logback.xml
+++ b/sonar-application/src/main/assembly/conf/logback.xml
@@ -37,15 +37,15 @@
     </encoder>
   </appender>
 
-    <!--
-    Profiling of HTTP requests. Set level to DEBUG in order to log all the HTTP and SQL requests.
-    Example of command-line to get the HTTP requests with execution time greater than 10s :
-    grep 'rails  Completed in [0-9]\{5,\}ms' < profiling.log
-   -->
-  <logger name="rails"  additivity="false">
+  <!--
+   Profiling of HTTP requests. Set level to DEBUG in order to log all the HTTP and SQL requests.
+   Example of command-line to get the HTTP requests with execution time greater than 10s :
+   grep 'rails  Completed in [0-9]\{5,\}ms' < profiling.log
+  -->
+  <logger name="rails" additivity="false">
     <level value="WARN"/>
     <appender-ref ref="PROFILING_FILE"/>
-  </logger> 
+  </logger>
 
 
   <logger name="org.hibernate.cache.ReadWriteCache">
@@ -57,12 +57,21 @@
     <level value="ERROR"/>
   </logger>
 
-  <!-- set DEBUG to activate Hibernate SQL logs. NOT RECOMMENDED  -->
-  <logger name="org.hibernate.SQL">
-    <level value="ERROR"/>
+  <logger name="org.hibernate">
+    <level value="WARN"/>
   </logger>
 
-  <logger name="org.hibernate">
+  <!-- Display SQL requests and results by setting the following loggers to level DEBUG -->
+  <logger name="org.hibernate.SQL">
+    <level value="WARN"/>
+  </logger>
+  <logger name="org.apache.ibatis">
+    <level value="WARN"/>
+  </logger>
+  <logger name="java.sql">
+    <level value="WARN"/>
+  </logger>
+  <logger name="java.sql.ResultSet">
     <level value="WARN"/>
   </logger>
 
-- 
cgit v1.2.3