Index: trunk/grails-app/conf/Config.groovy
===================================================================
--- trunk/grails-app/conf/Config.groovy	(revision 479)
+++ trunk/grails-app/conf/Config.groovy	(revision 480)
@@ -74,12 +74,6 @@
                         file:"${logDirectory}/${appName}.log".toString(),
                         maxFileSize:'300kB',
-                        maxBackupIndex:0,
+                        maxBackupIndex:1,
                         layout:pattern(conversionPattern: '%d{[EEE, dd-MMM-yyyy @ HH:mm:ss.SSS]} [%t] %-5p %c %x - %m%n')
-    }
-
-    // Configure the root logger to output to stdout and appLog appenders.
-    root {
-        error 'stdout','appLog'
-        additivity = true
     }
 
@@ -108,12 +102,28 @@
     switch(environment) {
         case 'development':
+            // Configure the root logger to output to stdout and appLog appenders.
+            root {
+                error 'stdout','appLog'
+                additivity = true
+            }
+            debug "org.hibernate.SQL"
             debug "grails.app.service"
             debug "grails.app.controller"
             break
         case 'test':
+            // Configure the root logger to only output to appLog appender.
+            root {
+                error 'appLog'
+                additivity = true
+            }
             debug "grails.app.service"
             debug "grails.app.controller"
             break
         case 'production':
+            // Configure the root logger to only output to appLog appender.
+            root {
+                error 'appLog'
+                additivity = true
+            }
             warn "grails.app.service"
             warn "grails.app.controller"