How to see queries being fired by hibernate?

Question

How do I see what queries are being fired by hibernate when a hibernate application is running in tomcat?

Accepted Answer

The fast answer is

```
hibernate.show_sql=true 
```

e.g. as in http://www.javalobby.org/java/forums/t44119.html

And from the official documentation:

hibernate.show_sql

Writes all SQL statements to console. This is an alternative to setting the log category org.hibernate.SQL to debug. e.g. true | false

hibernate.format_sql

Pretty print the SQL in the log and console. e.g. true | false

See this question as well: Hibernate show real SQL

Solution