### set log levels - for more verbose logging change 'info' to 'debug' ###
-log4j.rootLogger=warn, stdout
+log4j.rootLogger=warn, stdout, file
### *** CDM *** ###
log4j.logger.eu.etaxonomy.cdm = info
log4j.logger.eu.etaxonomy.cdm.database.init = warn
+#
log4j.logger.eu.etaxonomy.cdm.model.common.init = warn
+#
+log4j.logger.eu.etaxonomy.cdm.test.integration = info
log4j.logger.eu.etaxonomy.cdm.api.application = warn
+log4j.logger.eu.etaxonomy.cdm.api.service = info
+#log4j.logger.eu.etaxonomy.cdm.database.VocabularyStoreImpl = warn
+#
+log4j.logger.eu.etaxonomy.cdm.database = warn
+log4j.logger.eu.etaxonomy.cdm.persistence.dao.hibernate.common = warn
+
### *** SPRING ************ ###
-log4j.logger.org.springframework.transaction = info
-log4j.logger.org.hibernate.engine.LoadContexts = info
-log4j.logger.org.springframework.orm.hibernate3.SessionFactoryUtils = info
-log4j.logger.org.springframework.orm.hibernate3 = info
+log4j.logger.org.springframework.transaction = warn
+log4j.logger.org.hibernate.engine.LoadContexts = warn
+log4j.logger.org.springframework.orm.hibernate3.SessionFactoryUtils = warn
+log4j.logger.org.springframework.orm.hibernate3 = warn
log4j.logger.org.springframework.FileSystemXmlApplicationContext = warn;
-log4j.logger.org.springframework.core.io.support = info
+log4j.logger.org.springframework.core.io.support = warn
### ***HIBERNATE ************ ###
log4j.logger.org.hibernate=warn
### No warnings as thrown by SQLServer
-log4j.logger.org.hibernate.cfg = warn
+###log4j.logger.org.hibernate.cfg = warn
### No warnings as thrown by SQLServer
log4j.logger.org.hibernate.util.JDBCExceptionReporter = error
log4j.logger.org.hibernate.tool.hbm2ddl=warn
### log HQL parse trees
-#log4j.logger.org.hibernate.hql=debug
+log4j.logger.org.hibernate.hql=debug
+log4j.logger.org.hibernate.hql.ast=warn
### log cache activity ###
#log4j.logger.org.hibernate.cache=debug
### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace
+
+
+ ### *** 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
+