EDIT

### ************ APPENDER ***********************************###

### direct log messages to stdout ###

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.Target=System.out

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file hibernate.log ###

log4j.appender.file=org.apache.log4j.FileAppender

log4j.appender.file.File=target/hibernate.log

log4j.appender.file.layout=org.apache.log4j.PatternLayout

log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### ************* LOG LEVELS *********************************###

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=warn,stdout

log4j.logger.org.dbunit=error

### avoid warnings about inappropriate Annotations ###

# TODO remove the below two line after updating to hibernate 4.x

log4j.logger.org.hibernate.search.engine.DocumentBuilderContainedEntity=error

log4j.logger.org.hibernate.search.impl.SearchFactoryImpl=error

  ### *** jUnitBenchmarks *** ###

#log4j.logger.com.carrotsearch.junitbenchmarks=INFO

  ### *** CDM *** ###

#log4j.logger.eu.etaxonomy.cdm = info

#log4j.logger.eu.etaxonomy.cdm.database.init = debug

  ### *** SPRING ************ ###

#log4j.logger.org.springframework.transaction = warn

#log4j.logger.org.springframework.orm.hibernate3.SessionFactoryUtils = info

#log4j.logger.org.springframework.orm.hibernate3 = info

#log4j.logger.org.springframework.FileSystemXmlApplicationContext = warn

#log4j.logger.org.springframework.core.io.support = info

#### log spring security #####

#log4j.logger.eu.etaxonomy.cdm.persistence.hibernate.permission=debug

log4j.logger.eu.etaxonomy.cdm.persistence.hibernate.permission.CdmAuthority=warn

#log4j.logger.eu.etaxonomy.cdm.persistence.hibernate.CdmSecurityHibernateInterceptor=debug

#log4j.logger.org.springframework.security.access.intercept=debug

#log4j.logger.org.springframework.security.access.vote=debug

#log4j.logger.eu.etaxonomy.cdm.test.integration.CdmTransactionalIntegrationTest=debug

#org.dbunit.database.statement.AutomaticPreparedBatchStatement

  ### ***HIBERNATE ************ ###

#log4j.logger.org.hibernate=warn, file

#log4j.logger.org.hibernate.tool.hbm2ddl.SchemaExport = error

#log4j.logger.org.hibernate.engine.LoadContexts = error

#

#log4j.logger.org.hibernate.envers.event.AuditEventListener = debug, file

### No warnings as thrown by SQLServer

#log4j.logger.org.hibernate.cfg = warn

### No warnings as thrown by SQLServer

#log4j.logger.org.hibernate.util.JDBCExceptionReporter = error

### log HQL query parser activity

#log4j.logger.org.hibernate.hql.ast.AST=debug

### log just the SQL

# to log more context specific use this snipped in the code:

#     Logger.getLogger("org.hibernate.SQL").setLevel(Level.TRACE);

#log4j.logger.org.hibernate.SQL=TRACE

### log just hibernate processing queries 

#log4j.logger.org.hibernate.engine.query = TRACE

### log JDBC bind parameters ###

#log4j.logger.org.hibernate.type=TRACE

### log schema export/update ###

#log4j.logger.org.hibernate.tool.hbm2ddl=warn

### log HQL parse trees

#log4j.logger.org.hibernate.hql=debug

### log cache activity ###

#log4j.logger.org.hibernate.cache=debug

### log transaction management & binding

#log4j.logger.org.hibernate.transaction=debug

#log4j.logger.org.springframework.transaction.support.TransactionSynchronizationManager=trace

#log4j.logger.org.springframework.orm.hibernate3.HibernateTransactionManager=trace

#log4j.logger.org.springframework.orm.hibernate3=trace

### log AuditEvent Management ####

#log4j.logger.eu.etaxonomy.cdm.persistence.dao.hibernate.common.VersionableDaoBase=debug

### log JDBC resource acquisition

#log4j.logger.org.hibernate.jdbc=info

### log hibernate id generation

#log4j.logger.org.hibernate.id = INFO

### enable the following line if you want to track down connection ###

### leakages when using DriverManagerConnectionProvider ###

#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace

###  hibernate search & Lucene

#log4j.logger.eu.etaxonomy.cdm.search.LuceneSearch=info

### log CDM-Updater

log4j.logger.eu.etaxonomy.cdm.database.update=info

   ### *** Profiling Logger ************ ###

#log4j.logger.org.springframework.aop.interceptor.PerformanceMonitorInterceptor=TRACE, profiling

### Profiling output

#log4j.appender.profiling=org.apache.log4j.RollingFileAppender

#log4j.appender.profiling.File=profiling.log

#log4j.appender.profiling.MaxFileSize=1024KB

#log4j.appender.profiling.MaxBackupIndex=1

#log4j.appender.profiling.layout=org.apache.log4j.PatternLayout

#log4j.appender.profiling.layout.conversionPattern=%d,%p,%m%n

### log dbUnit data loading

#log4j.appender.org.unitils.dbunit=debug

#log4j.appender.org.dbunit=debug

#log4j.appender.org.dbunit.database.statement=debug

#log4j.appender.org.dbunit.database.DatabaseConfig=trace