Show Hibernate SQL Query in Spring Boot

In this short Spring Boot tutorial, I am going to share with you how to make Spring Boot app show Hibernate SQL Queries.

Enable Hibernate SQL Queries Logging

To show hibernate SQL queries in Spring Boot log file you will need to update the file with the following details:

Show SQL Values

Additionally, to logging Hibernate SQL Queries, you can make your Spring Boot show the values which are being used in the SQL query, update file by adding the following line:

Show JPA SQL Queries

If you use Spring Data JPA then you can log SQL queries by updating your file by adding:

Format Hibernate SQL Query

You can also make SQL queries display in your log file in a very friendly to read format. To format SQL queries add the following property to file.

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, then check out the below list of Spring Boot video courses.

Leave a Reply

Your email address will not be published. Required fields are marked *