In this tutorial, I will share how to make the Spring Boot application display Hibernate SQL Queries.
If you are learning about Hibernate, you might also be interested in the following tutorials:
- One-to-One Mapping Hibernate/JPA Using Spring Boot and MySQL
- One-to-Many Mapping Hibernate/JPA Using Spring Boot and MySQL
- Many-to-Many Relationship in Spring Boot Rest +JPA
Enable Hibernate SQL Queries Logging
To show hibernate SQL queries in the Spring Boot log file, you will need to update the application.properties file with the following details:
logging.level.org.hibernate.SQL=debug
Show SQL Values
Additionally, to logging Hibernate SQL Queries, you can make your Spring Boot show the values that are being used in the SQL query. To do that, update application.properties file by adding the following line:
logging.level.org.hibernate.type.descriptor.sql=trace
Show JPA SQL Queries
If you use Spring Data JPA, then you can log SQL queries by updating your application.properties file by adding:
spring.jpa.show-sql=true
Format Hibernate SQL Query
You can also display SQL queries in your log file in a very user-friendly format. To format SQL queries add the following property to the application.properties file.
spring.jpa.properties.hibernate.format_sql=true
Enable Hibernate SQL Query Logging Video Tutorial
To learn more about Building and Testing RESTful Web Services with Spring Boot, please check the following page: RESTful Web Services with Spring MVC.
I hope this Spring Boot tutorial was helpful to you. If you like learning by watching video lessons, check out the Spring Boot video courses below.
