With all the preliminaries out of the way, now I can talk about appropriate logging levels in Hibernate. Setting org.hibernate.SQL to at least DEBUG/FINE shows the SQL statements that are executed. Setting org.hibernate.type to at lest DEBUG/FINEST shows the values bound to variables in the SQL statements -- but be warned that this is very verbose.
The Hibernate manual details all of the logging properties.