Hibernate show real SQL?

Question

if I set <property name="show_sql">true</property> in my **hibernate.cfg.xml** configuration file in the console I can see the SQL. But it's not *real* SQL... Can I see the SQL code that will be passed directly to database? Example: I see select this_.code from true.employee this_ where this_.code=? Can I see select employee.code from employee where employee.code=12 the *real* SQL?

Answer 1

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.