Hibernate show real SQL [duplicate]

by

Can I see (…) the real SQL

If you want to see the SQL sent directly to the database (that is formatted similar to your example), you’ll have to use some kind of jdbc driver proxy like P6Spy (or log4jdbc).

Alternatively you can enable logging of the following categories (using a log4j.properties file here):

log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.hibernate.type=TRACE

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

Reference

More Related Contents:

  1. How to print a query string with parameter values when using Hibernate
  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. When and why JPA entities should implement the Serializable interface?
  6. How should equals and hashcode be implemented when using JPA and Hibernate
  7. I found JPA, or alike, don’t encourage DAO pattern
  8. Getting Database connection in pure JPA setup
  9. Hibernate – @ElementCollection – Strange delete/insert behavior
  10. session.connection() deprecated on Hibernate?
  11. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  12. Postgresql UUID supported by Hibernate?
  13. how to configure hibernate config file for sql server
  14. Hibernate, iBatis, Java EE or other Java ORM tool
  15. How can I use hibernate with MS Access?
  16. Hibernate use of PostgreSQL sequence does not affect sequence table
  17. Primitive or wrapper for hibernate primary keys
  18. Hibernate Group by Criteria Object
  19. Hibernate Named Query Order By parameter
  20. Is it possible to dynamically define column names in Hibernate / JPA?
  21. How to use Hibernate @Any-related annotations?
  22. How do you map a “Map” in hibernate using annotations?
  23. How to turn off hbm2ddl?
  24. Hibernate triggering constraint violations using orphanRemoval
  25. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  26. Change Table Name of an Entity on runtime? [duplicate]
  27. Hibernate saving User model to Postgres
  28. HQL recursion, how do I do this?
  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