From 0001b90092c805c5c2d4a62b53fe9c86fef41b0d Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Wed, 3 Oct 2012 18:28:47 +0200
Subject: [PATCH] Log Hibernate/MyBatis SQL requests in development mode

---
 sonar-server/src/dev/h2/conf/logback.xml         | 12 +++++++++++-
 sonar-server/src/dev/mysql/conf/logback.xml      | 12 +++++++++++-
 sonar-server/src/dev/postgresql/conf/logback.xml | 12 +++++++++++-
 3 files changed, 33 insertions(+), 3 deletions(-)

diff --git a/sonar-server/src/dev/h2/conf/logback.xml b/sonar-server/src/dev/h2/conf/logback.xml
index 6548deb530e..a6892222c82 100644
--- a/sonar-server/src/dev/h2/conf/logback.xml
+++ b/sonar-server/src/dev/h2/conf/logback.xml
@@ -9,8 +9,18 @@
     </encoder>
   </appender>
 
+  <!-- Display SQL requests and results by setting the following loggers to level DEBUG -->
   <logger name="org.hibernate.SQL">
-    <level value="ERROR"/>
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="org.apache.ibatis">
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="java.sql">
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="java.sql.ResultSet">
+    <level value="DEBUG"/>
   </logger>
 
   <logger name="org.hibernate.cache.ReadWriteCache">
diff --git a/sonar-server/src/dev/mysql/conf/logback.xml b/sonar-server/src/dev/mysql/conf/logback.xml
index 6548deb530e..a6892222c82 100644
--- a/sonar-server/src/dev/mysql/conf/logback.xml
+++ b/sonar-server/src/dev/mysql/conf/logback.xml
@@ -9,8 +9,18 @@
     </encoder>
   </appender>
 
+  <!-- Display SQL requests and results by setting the following loggers to level DEBUG -->
   <logger name="org.hibernate.SQL">
-    <level value="ERROR"/>
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="org.apache.ibatis">
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="java.sql">
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="java.sql.ResultSet">
+    <level value="DEBUG"/>
   </logger>
 
   <logger name="org.hibernate.cache.ReadWriteCache">
diff --git a/sonar-server/src/dev/postgresql/conf/logback.xml b/sonar-server/src/dev/postgresql/conf/logback.xml
index 6548deb530e..a6892222c82 100644
--- a/sonar-server/src/dev/postgresql/conf/logback.xml
+++ b/sonar-server/src/dev/postgresql/conf/logback.xml
@@ -9,8 +9,18 @@
     </encoder>
   </appender>
 
+  <!-- Display SQL requests and results by setting the following loggers to level DEBUG -->
   <logger name="org.hibernate.SQL">
-    <level value="ERROR"/>
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="org.apache.ibatis">
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="java.sql">
+    <level value="DEBUG"/>
+  </logger>
+  <logger name="java.sql.ResultSet">
+    <level value="DEBUG"/>
   </logger>
 
   <logger name="org.hibernate.cache.ReadWriteCache">
-- 
2.39.5