How to print a query string with parameter values when using Hibernate

Question

You need to enable logging for the the following categories:

org.hibernate.SQL – set to debug to log all SQL DML statements as they are executed
org.hibernate.type – set to trace to log all JDBC parameters

So a log4j configuration could look like:

# logs the SQL statements
log4j.logger.org.hibernate.SQL=debug 

# Logs the JDBC parameters passed to a query
log4j.logger.org.hibernate.type=trace

The first is equivalent to hibernate.show_sql=true legacy property, the second prints the bound parameters among other things.

Another solution (non hibernate based) would be to use a JDBC proxy driver like P6Spy.