How Can I See the Real Parameter Values in My Hibernate SQL Queries?

Hibernate SQL query parameter value viewing method

When executing queries with Hibernate, it is often useful to see the actual parameter values ​​passed to the database.

Can Hibernate directly display the actual parameter values?

Unfortunately, Hibernate itself does not provide a mechanism to directly print the SQL query containing the actual parameter values. Question marks in SQL statements represent placeholder parameters, and Hibernate will not automatically replace them with actual parameter values.

Logging Alternatives

To see the actual SQL query string containing the parameter values, you can enable logging for a specific Hibernate class:

• org.hibernate.SQL: Set to "debug" to log all executed SQL DML statements.
• org.hibernate.type: Set to "trace" to log all JDBC parameters.

The following log4j configuration illustrates this approach:

<code>log4j.logger.org.hibernate.SQL=debug

# 记录传递给查询的JDBC参数
log4j.logger.org.hibernate.type=trace</code>

This method is similar to the old hibernate.show_sql=true attribute. It's worth noting that enabling org.hibernate.type logging will log more information, including binding parameters.

External proxy driver

Another method is to use a JDBC proxy driver such as P6Spy. P6Spy intercepts JDBC calls and allows you to inspect the actual SQL query and parameter values ​​sent to the database.

The above is the detailed content of How Can I See the Real Parameter Values in My Hibernate SQL Queries?. For more information, please follow other related articles on the PHP Chinese website!