Show Hibernate SQL Query in Spring Boot


In this post, I am going to share how to show Hibernate SQL queries on the console log while running your Spring Boot project(s).

Spring Boot Console

Enable Hibernate SQL Queries Logging

To show hibernate SQL queries in the 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: language: JavaScript (javascript)

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. language: JavaScript (javascript)

Leave a Reply

Discover more from BHUTAN IO

Subscribe now to keep reading and get access to the full archive.

Continue reading

Scroll to Top