I am using Hibernation 3.0.2 with annotations thus no *.cfg.xml file. I am wondering how could I log the sql queries generated by hibernate

You can use p6spy to log sql commands. In addition, you can configure hibernate to print out hql commands. Refer to Table 3.3. Hibernate Configuration Properties section in hibernate documentation for a full list of properties.

The properties you'll need are:
hibernate.show_sql
hibernate.format_sql

You can set both in the persistence.xml and in the hibernate specific configuration file (don't know the name, I use always the persistence.xml file).

Examples will you find here:

The properties you'll need are:
hibernate.show_sql
hibernate.format_sql

You can set both in the persistence.xml and in the hibernate specific configuration file (don't know the name, I use always the persistence.xml file).

Examples will you find here:
http://www.hibernate.org/hib_docs/refer ... ation.html