How to print a query string with parameter values when using Hibernate

by

You need to enable logging for the the following categories:

  • org.hibernate.SQL   – set to debug to log all SQL DML statements as they are executed
  • org.hibernate.type – set to trace to log all JDBC parameters

So a log4j configuration could look like:

# logs the SQL statements
log4j.logger.org.hibernate.SQL=debug 

# Logs the JDBC parameters passed to a query
log4j.logger.org.hibernate.type=trace

The first is equivalent to hibernate.show_sql=true legacy property, the second prints the bound parameters among other things.

Another solution (non hibernate based) would be to use a JDBC proxy driver like P6Spy.

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  3. Hibernate Annotations – Which is better, field or property access?
  4. How to map calculated properties with JPA and Hibernate
  5. Bypass GeneratedValue in Hibernate (merge data not in db?)
  6. How should equals and hashcode be implemented when using JPA and Hibernate
  7. Hibernate Union alternatives
  8. I found JPA, or alike, don’t encourage DAO pattern
  9. Hibernate – @ElementCollection – Strange delete/insert behavior
  10. session.connection() deprecated on Hibernate?
  11. Automatic reserved word escaping for Hibernate tables and columns
  12. Location of hibernate.cfg.xml in project?
  13. What’s the use of session.flush() in Hibernate
  14. how to configure hibernate config file for sql server
  15. How to set a default entity property value with Hibernate
  16. mappedBy reference an unknown target entity property
  17. Hibernate use of PostgreSQL sequence does not affect sequence table
  18. Primitive or wrapper for hibernate primary keys
  19. Hibernate Group by Criteria Object
  20. Enum in Hibernate, persisting as an enum
  21. Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)
  22. How to prevent SQL Injection with JPA and Hibernate?
  23. How to use Hibernate @Any-related annotations?
  24. How to turn off hbm2ddl?
  25. Hibernate triggering constraint violations using orphanRemoval
  26. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  27. Get column name of property mapped with Hibernate
  28. How to escape colon `:` within a native SQL query in Hibernate?
  29. How to map one class to different tables using hibernate/jpa annotations
  30. How to use JTA support in Tomcat 6 for Hibernate?

Leave a Comment