logback example corrected

1 files changed, 21 insertions, 0 deletions

diff --git a/juick-core/src/main/resources/logback.xml.example b/juick-core/src/main/resources/logback.xml.example
index d80b4b33..05a3cfdf 100644
--- a/juick-core/src/main/resources/logback.xml.example
+++ b/juick-core/src/main/resources/logback.xml.example
@@ -8,6 +8,27 @@
         </encoder>
     </appender>
 
+    <!-- log SQL (pre-execution) plus exceptions caused by SQL -->
+    <!-- <logger name="jdbc.sqlonly" level="debug"/>-->
+
+    <!-- log SQL with timing information, post execution -->
+    <!-- <logger name="jdbc.sqltiming" level="debug"/> -->
+
+    <!-- only use the two logs below to trace ALL JDBC information, NOTE: This can be very voluminous! -->
+
+    <!-- log all jdbc calls except ResultSet calls -->
+    <!-- <logger name="jdbc.audit" level="debug"/> -->
+
+    <!-- log the jdbc ResultSet calls -->
+    <!-- <logger name="jdbc.resultset" level="debug"/> -->
+
+    <!-- log connection open/close events and dump of all open connection numbers -->
+    <!-- <logger name="jdbc.connection" level="debug"/> -->
+
+    <!-- this log is for internal debugging of log4jdbc, itself -->
+    <!-- debug logging for log4jdbc itself -->
+    <!-- <logger name="log4jdbc.debug" level="debug"/> -->
+
     <root level="info">
         <appender-ref ref="STDOUT" />
     </root>