How to Log SQL Statements in Spring Boot?

Logging SQL Statements in Spring Boot

In Spring Boot, you can configure logging to output SQL statements to a file. This can be useful for debugging or tracing the execution of database operations. By default, Spring Boot does not log SQL statements.

To log SQL statements, you can add the following properties to your application.properties file:

logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE

The above properties set the logging level for the Hibernate SQL logger and the BasicBinder logger to DEBUG and TRACE respectively. This will log all SQL statements and their bound parameters.

Once you have added these properties, you can run your application and check the log file to see the SQL statements.

The above is the detailed content of How to Log SQL Statements in Spring Boot?. For more information, please follow other related articles on the PHP Chinese website!