| 1 | ### direct log messages to stdout ### |
|---|
| 2 | log4j.appender.stdout=org.apache.log4j.ConsoleAppender |
|---|
| 3 | log4j.appender.stdout.Target=System.out |
|---|
| 4 | log4j.appender.stdout.layout=org.apache.log4j.PatternLayout |
|---|
| 5 | log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n |
|---|
| 6 | |
|---|
| 7 | ### set log levels - for more verbose logging change 'info' to 'debug' ### |
|---|
| 8 | # setting can be: all, debug, info, warn, error, fatal or off |
|---|
| 9 | |
|---|
| 10 | log4j.rootLogger=warn, stdout |
|---|
| 11 | |
|---|
| 12 | |
|---|
| 13 | # ------------------- |
|---|
| 14 | # Base 2 CORE loggers |
|---|
| 15 | # ------------------- |
|---|
| 16 | ### Core logger |
|---|
| 17 | log4j.logger.net.sf.basedb.core=warn |
|---|
| 18 | #log4j.logger.net.sf.basedb.core=info |
|---|
| 19 | |
|---|
| 20 | ### Log batcher SQL generation |
|---|
| 21 | #log4j.logger.net.sf.basedb.core.batcher.sql=debug |
|---|
| 22 | |
|---|
| 23 | ### Log batcher parameter binding |
|---|
| 24 | #log4j.logger.net.sf.basedb.core.batcher.bind=debug |
|---|
| 25 | |
|---|
| 26 | ### Log Query API HQL/SQL generation |
|---|
| 27 | #log4j.logger.net.sf.basedb.core.query.ql=debug |
|---|
| 28 | |
|---|
| 29 | ### Log Query API parameter binding |
|---|
| 30 | #log4j.logger.net.sf.basedb.core.query.bind=debug |
|---|
| 31 | |
|---|
| 32 | ### Log Internal Job queue events |
|---|
| 33 | #log4j.logger.net.sf.basedb.core.InternalJobQueue=debug |
|---|
| 34 | |
|---|
| 35 | ### Log Internal Secondary storage controller |
|---|
| 36 | #log4j.logger.net.sf.basedb.core.storage=debug |
|---|
| 37 | |
|---|
| 38 | ### Log Signal handling events |
|---|
| 39 | #log4j.logger.net.sf.basedb.core.signal=debug |
|---|
| 40 | |
|---|
| 41 | ### Extensions API |
|---|
| 42 | #log4j.logger.net.sf.basedb.util.extensions=debug |
|---|
| 43 | #log4j.logger.net.sf.basedb.clients.web.extensions=debug |
|---|
| 44 | |
|---|
| 45 | ### Overview generation |
|---|
| 46 | #log4j.logger.net.sf.basedb.util.overview=debug |
|---|
| 47 | |
|---|
| 48 | |
|---|
| 49 | # ----------------- |
|---|
| 50 | # Job agent loggers |
|---|
| 51 | # ----------------- |
|---|
| 52 | log4j.logger.net.sf.basedb.clients.jobagent=warn |
|---|
| 53 | |
|---|
| 54 | # ----------------- |
|---|
| 55 | # Hibernate loggers |
|---|
| 56 | # ----------------- |
|---|
| 57 | log4j.logger.org.hibernate=off |
|---|
| 58 | #log4j.logger.org.hibernate=debug |
|---|
| 59 | |
|---|
| 60 | ### log HQL query parser activity |
|---|
| 61 | #log4j.logger.org.hibernate.hql.ast.AST=debug |
|---|
| 62 | |
|---|
| 63 | ### log just the SQL |
|---|
| 64 | #log4j.logger.org.hibernate.SQL=debug |
|---|
| 65 | |
|---|
| 66 | ### log JDBC bind parameters ### |
|---|
| 67 | #log4j.logger.org.hibernate.type=info |
|---|
| 68 | #log4j.logger.org.hibernate.type=debug |
|---|
| 69 | |
|---|
| 70 | ### log schema export/update ### |
|---|
| 71 | #log4j.logger.org.hibernate.tool.hbm2ddl=debug |
|---|
| 72 | #log4j.logger.net.sf.basedb.core.hibernate.SchemaGenerator=debug |
|---|
| 73 | |
|---|
| 74 | ### log HQL parse trees |
|---|
| 75 | #log4j.logger.org.hibernate.hql=debug |
|---|
| 76 | |
|---|
| 77 | ### log cache activity ### |
|---|
| 78 | #log4j.logger.org.hibernate.cache=debug |
|---|
| 79 | |
|---|
| 80 | ### log transaction activity |
|---|
| 81 | #log4j.logger.org.hibernate.transaction=debug |
|---|
| 82 | |
|---|
| 83 | ### log JDBC resource acquisition |
|---|
| 84 | #log4j.logger.org.hibernate.jdbc=debug |
|---|
| 85 | |
|---|
| 86 | ### enable the following line if you want to track down connection ### |
|---|
| 87 | ### leakages when using DriverManagerConnectionProvider ### |
|---|
| 88 | #log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace |
|---|
| 89 | |
|---|
| 90 | |
|---|
| 91 | |
|---|
| 92 | |
|---|
