java - Hibernate show real SQL

Question

This question already has answers here:

Answer 1

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

• Hibernate 3.5 Core Documentation
  • 3.5. Logging
• Hibernate 4.1 Core Documentation
  • 4.1. Logging