How Can I Print SQL Queries with Real Parameter Values in Hibernate or JDBC?

How to Print a SQL Query with Real Parameter Values Using Hibernate or JDBC Proxies

In Hibernate, printing generated SQL queries with question marks instead of real values can be frustrating. This article will explore two solutions to overcome this limitation.

Solution 1: Enabling Hibernate Logging

To enable logging with parameter values, configure the following Hibernate logging categories:

• org.hibernate.SQL (set to debug)
• org.hibernate.type (set to trace)

A sample log4j configuration for this approach looks like this:

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

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

Solution 2: Using JDBC Proxy Drivers

Another alternative is to use a JDBC proxy driver such as P6Spy. These drivers intercept and monitor database interactions, providing access to query and parameter information.

Conclusion

Both solutions enable you to print SQL queries with real values, making it easier to debug and optimize your Hibernate or JDBC applications.

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