Enabling Hibernate SQL Statement logging in Hibernate configuration
Alternately, you can configure Hibernate to send all SQL messages to log4j, using a specific facility: log4j.logger.org.hibernate.SQL=DEBUG, SQL_APPENDER log4j.additivity.org.hibernate.SQL=false