From b4c6a1dd6bc8798ef2d0110e081ae180f930ffdb Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Tue, 14 May 2013 10:13:52 +0200
Subject: [PATCH] Add debug logs in dev mode

---
 sonar-server/src/dev/mysql/conf/logback.xml   | 21 +++++++++++++------
 .../src/dev/postgresql/conf/logback.xml       | 21 +++++++++++++------
 2 files changed, 30 insertions(+), 12 deletions(-)

diff --git a/sonar-server/src/dev/mysql/conf/logback.xml b/sonar-server/src/dev/mysql/conf/logback.xml
index 1bde810d728..a5dca488705 100644
--- a/sonar-server/src/dev/mysql/conf/logback.xml
+++ b/sonar-server/src/dev/mysql/conf/logback.xml
@@ -9,22 +9,31 @@
     </encoder>
   </appender>
 
+  <logger name="rails">
+    <level value="DEBUG"/>
+  </logger>
+
   <logger name="org.hibernate.cache.ReadWriteCache">
     <!-- removing "An item was expired by the cache while it was locked (increase your cache timeout)" msg -->
     <level value="ERROR"/>
   </logger>
-
-  <logger name="org.sonar.INFO">
-    <level value="INFO"/>
+  <logger name="org.hibernate">
+    <level value="WARN"/>
   </logger>
 
-  <logger name="rails">
+  <!-- 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="DEBUG"/>
   </logger>
-
-  <logger name="org.sonar.MEASURE_FILTER">
+  <logger name="java.sql">
     <level value="DEBUG"/>
   </logger>
+  <logger name="java.sql.ResultSet">
+    <level value="WARN"/>
+  </logger>
 
   <root>
     <level value="INFO"/>
diff --git a/sonar-server/src/dev/postgresql/conf/logback.xml b/sonar-server/src/dev/postgresql/conf/logback.xml
index 1bde810d728..a5dca488705 100644
--- a/sonar-server/src/dev/postgresql/conf/logback.xml
+++ b/sonar-server/src/dev/postgresql/conf/logback.xml
@@ -9,22 +9,31 @@
     </encoder>
   </appender>
 
+  <logger name="rails">
+    <level value="DEBUG"/>
+  </logger>
+
   <logger name="org.hibernate.cache.ReadWriteCache">
     <!-- removing "An item was expired by the cache while it was locked (increase your cache timeout)" msg -->
     <level value="ERROR"/>
   </logger>
-
-  <logger name="org.sonar.INFO">
-    <level value="INFO"/>
+  <logger name="org.hibernate">
+    <level value="WARN"/>
   </logger>
 
-  <logger name="rails">
+  <!-- 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="DEBUG"/>
   </logger>
-
-  <logger name="org.sonar.MEASURE_FILTER">
+  <logger name="java.sql">
     <level value="DEBUG"/>
   </logger>
+  <logger name="java.sql.ResultSet">
+    <level value="WARN"/>
+  </logger>
 
   <root>
     <level value="INFO"/>
-- 
2.39.5