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