Skip to content

Instantly share code, notes, and snippets.

@praveenhm
Last active December 21, 2015 03:39
Show Gist options
  • Save praveenhm/6244259 to your computer and use it in GitHub Desktop.
Save praveenhm/6244259 to your computer and use it in GitHub Desktop.
log4j hibernate
### Log everything (a lot of information, but very useful for troubleshooting) ###
#log4j.logger.org.hibernate=info
### Log HQL and SQL ASTs during query parsing ###
log4j.logger.org.hibernate.hql.ast.AST=DEBUG, SQL_APPENDER
log4j.additivity.org.hibernate.hql.ast.AST=false
### log just the SQL
log4j.logger.org.hibernate.SQL=DEBUG, SQL_APPENDER
log4j.additivity.org.hibernate.SQL=false
### log JDBC bind parameters. Very userfull, when debug parameterized queries ###
log4j.logger.org.hibernate.type=TRACE, SQL_APPENDER
log4j.additivity.org.hibernate.type=false
### log schema export/update ###
#log4j.logger.org.hibernate.tool.hbm2ddl=info
### log HQL parse trees
#log4j.logger.org.hibernate.hql=debug
### log cache activity ###
#log4j.logger.org.hibernate.cache=info
### log transaction activity
#log4j.logger.org.hibernate.transaction=debug
### Log all JDBC resource acquisition
#log4j.logger.org.hibernate.jdbc=debug
### delete this
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment