Show Hibernate parameters with nicely formatted query

Sometime for the debugging it is really handy, to do it, you need:

log4j.properties

log4j.logger.org.hibernate=INFO, hb log4j.logger.org.hibernate.SQL=DEBUG log4j.logger.org.hibernate.type=TRACE log4j.logger.org.hibernate.hql.ast.AST=info log4j.logger.org.hibernate.tool.hbm2ddl=warn log4j.logger.org.hibernate.hql=debug log4j.logger.org.hibernate.cache=info log4j.logger.org.hibernate.jdbc=debug log4j.appender.hb=org.apache.log4j.ConsoleAppender log4j.appender.hb.layout=org.apache.log4j.PatternLayout log4j.appender.hb.layout.ConversionPattern=HibernateLog --> %d{HH:mm:ss} %-5p %c - %m%n log4j.appender.hb.Threshold=TRACE hibernate.cfg.xml <property name="show_sql">true</property> <property name="format_sql">true</property> <property name="use_sql_comments">true</property>

Thanks Tommaso Taruffi, http://stackoverflow.com/questions/2536829/hibernate-show-real-sql