Configuring Hibernate logging using Log4j XML config file?

by

From http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-logging

Here’s the list of logger categories:

Category                    Function

org.hibernate.SQL           Log all SQL DML statements as they are executed
org.hibernate.type          Log all JDBC parameters
org.hibernate.tool.hbm2ddl  Log all SQL DDL statements as they are executed
org.hibernate.pretty        Log the state of all entities (max 20 entities) associated with the session at flush time
org.hibernate.cache         Log all second-level cache activity
org.hibernate.transaction   Log transaction related activity
org.hibernate.jdbc          Log all JDBC resource acquisition
org.hibernate.hql.ast.AST   Log HQL and SQL ASTs during query parsing
org.hibernate.secure        Log all JAAS authorization requests
org.hibernate               Log everything (a lot of information, but very useful for troubleshooting)

Formatted for pasting into a log4j XML configuration file:

<!-- Log all SQL DML statements as they are executed -->
<Logger name="org.hibernate.SQL" level="debug" />
<!-- Log all JDBC parameters -->
<Logger name="org.hibernate.type" level="debug" />
<!-- Log all SQL DDL statements as they are executed -->
<Logger name="org.hibernate.tool.hbm2ddl" level="debug" />
<!-- Log the state of all entities (max 20 entities) associated with the session at flush time -->
<Logger name="org.hibernate.pretty" level="debug" />
<!-- Log all second-level cache activity -->
<Logger name="org.hibernate.cache" level="debug" />
<!-- Log transaction related activity -->
<Logger name="org.hibernate.transaction" level="debug" />
<!-- Log all JDBC resource acquisition -->
<Logger name="org.hibernate.jdbc" level="debug" />
<!-- Log HQL and SQL ASTs during query parsing -->
<Logger name="org.hibernate.hql.ast.AST" level="debug" />
<!-- Log all JAAS authorization requests -->
<Logger name="org.hibernate.secure" level="debug" />
<!-- Log everything (a lot of information, but very useful for troubleshooting) -->
<Logger name="org.hibernate" level="debug" />

NB: Most of the loggers use the DEBUG level, however org.hibernate.type uses TRACE. In previous versions of Hibernate org.hibernate.type also used DEBUG, but as of Hibernate 3 you must set the level to TRACE (or ALL) in order to see the JDBC parameter binding logging.

And a category is specified as such:

<logger name="org.hibernate">
    <level value="ALL" />
    <appender-ref ref="FILE"/>
</logger>

It must be placed before the root element.

More Related Contents:

  1. Eclipse: Referencing log4j.dtd in log4j.xml
  2. Using system environment variables in log4j xml configuration
  3. How to configure Spring Data JPA using XML
  4. How to specify Log4J 2.x config location?
  5. Enable Hibernate logging
  6. Why chose XML over properties files for Log4J configuration?
  7. How to Create a Custom Appender in log4j2?
  8. How can I create 2 separate log files with one log4j config file?
  9. XPath: select text node
  10. XML Namespaces and Unprefixed Attributes
  11. log4j configuration via JVM argument(s)?
  12. How to iterate over IDREFS values in XSLT 1.0?
  13. XSLT 1.0 Group By
  14. XPath: Get parent node from child node
  15. Android Custom View Constructor
  16. XML Validation with XSD in Visual Studio IDE
  17. Is there an XSLT name-of element?
  18. How to convert newline into with XSLT? [duplicate]
  19. Get Nth child of a node using xpath
  20. How to implement if-else statement in XSLT?
  21. JAXB: How to marshal objects in lists?
  22. Combine values in huge XML-files
  23. XML Schema that allows anything (xsd:any)
  24. What is the correct XPath for choosing attributes that contain “foo”?
  25. How to log using log4j to local file system inside a Spark application that runs on YARN?
  26. Traversing all nodes in an XML file with VBScript
  27. Node.js: how to consume SOAP XML web service
  28. What is an xs:NCName type and when should it be used?
  29. Is it possible to apply normalize-space to all nodes XPath expression finds?
  30. How to add a newline (line break) in an XML file?

Leave a Comment