############################################################################################
# Default configuration file for log4j. 
#
# This properties file is used if no other configuration if log4j is done explicitly.
############################################################################################


# Root logger reports everything and uses the console appender
log4j.rootLogger=ERROR, console

# Log level for wamblee.org
log4j.logger.org.wamblee=INFO
log4j.logger.org.wamblee.usermgt.UserAdministrationImplTest=INFO
log4j.logger.org.wamblee.security.authorization=ERROR
log4j.logger.org.wamblee.cache=INFO


log4j.logger.org.springframework=ERROR
log4j.logger.net.sf.ehcache=WARN

# Default log level for hibernate
log4j.logger.org.hibernate=ERROR
log4j.logger.org.hibernate3=ERROR

log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n

######################################################################################
# Hibernate SQL logging, switch the log level to DEBUG to see the output. 
######################################################################################

log4j.logger.org.wamblee.test.SpringTestCase=ERROR, console
log4j.additivity.org.wamblee.test.SpringTestCase=false

# Logging for queries.
log4j.logger.org.hibernate.SQL=ERROR, sql
log4j.additivity.org.hibernate.SQL=false

# Logging for query parameters and return values.  
log4j.logger.org.hibernate.type=ERROR, sqltype
log4j.additivity.org.hibernate.type=false

# Appender for the queries
log4j.appender.sql=org.apache.log4j.ConsoleAppender
log4j.appender.sql.layout=org.apache.log4j.PatternLayout
log4j.appender.sql.layout.ConversionPattern=%n%-4r [%t] SQL: %x - %m%n

# Appender to show the actual parameters and return values of the queries. 
log4j.appender.sqltype=org.apache.log4j.ConsoleAppender
log4j.appender.sqltype.layout=org.apache.log4j.PatternLayout
log4j.appender.sqltype.layout.ConversionPattern=%-4r [%t] SQL:     %x - %m%n