Enable Hibernate logging

by

Hibernate logging has to be also enabled in hibernate configuration.

Add lines

hibernate.show_sql=true
hibernate.format_sql=true

either to

server\default\deployers\ejb3.deployer\META-INF\jpa-deployers-jboss-beans.xml

or to application’s persistence.xml in <persistence-unit><properties> tag.

Anyway hibernate logging won’t include (in useful form) info on actual prepared statements’ parameters.

There is an alternative way of using log4jdbc for any kind of sql logging.

The above answer assumes that you run the code that uses hibernate on JBoss, not in IDE.
In this case you should configure logging also on JBoss in server\default\deploy\jboss-logging.xml, not in local IDE classpath.

Note that JBoss 6 doesn’t use log4j by default. So adding log4j.properties to ear won’t help.
Just try to add to jboss-logging.xml:

   <logger category="org.hibernate">
     <level name="DEBUG"/>
   </logger>

Then change threshold for root logger. See SLF4J logger.debug() does not get logged in JBoss 6.

If you manage to debug hibernate queries right from IDE (without deployment), then you should have log4j.properties, log4j, slf4j-api and slf4j-log4j12 jars on classpath.
See http://www.mkyong.com/hibernate/how-to-configure-log4j-in-hibernate-project/.

More Related Contents:

  1. How to Create a Custom Appender in log4j2?
  2. Setting a log file name to include current date in Log4j
  3. How can I log SQL statements in Spring Boot?
  4. Turning off hibernate logging console output
  5. Configuring Log4j Loggers Programmatically
  6. How can I create 2 separate log files with one log4j config file?
  7. In log4j, does checking isDebugEnabled before logging improve performance?
  8. log4j configuration via JVM argument(s)?
  9. Is it worth to use slf4j with log4j2
  10. How to send java.util.logging to log4j?
  11. Log4j: How to configure simplest possible file logging?
  12. how to make log4j to write to the console as well
  13. How to send a stacktrace to log4j?
  14. How to configure log4j to log different log levels to different files for the same logger
  15. Redirect System.out and System.err to slf4j
  16. How to customize log4j2 RollingFileAppender?
  17. Are there technical reasons to prefer using logback instead of log4j?
  18. Where do I configure log4j in a JUnit test class?
  19. How to specify Log4J 2.x config location?
  20. Configuring RollingFileAppender in log4j
  21. Log4j formatting: Is it possible to truncate stacktraces?
  22. How to exclude a single Class from a Log4j Logger / Appender?
  23. Configuring log4j2 and log4j using a single log4j2 xml file
  24. Log runtime Exceptions in Java using log4j
  25. How to configure log4j to only keep log files for the last seven days?
  26. Why chose XML over properties files for Log4J configuration?
  27. How to create different log files for different packages using same log4j logger?
  28. Log4j2 (2.1) custom plugin not detected by packages attribute
  29. log4j migration to log4j2
  30. Log4J: Strategies for creating Logger instances

Leave a Comment