Spring Boot : How to enable Hibernate SQL Logging using application.properties

How to enable Hibernate SQL Logging in Spring Boot using application.properties

You can enable hibernate sql logging level to Debug. This will print the sql queries fired by hibernate.

logging.level.org.hibernate.SQL=DEBUG

Your complete SQL configuration may look like following

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://localhost/ekiras
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
logging.level.org.hibernate.SQL=DEBUG