How to view Hibernate query?

If you want to see the Hibernate generated SQL statements on console, what should you do?

In Hibernate configuration file set as follows:

<session-factory >
...
<property name="show_sql">true</property>
...
</session-factory >