How to Prevent Hibernate SQL Logging to Console in Spring Boot with Logback

How can I stop Hibernate from logging SQL statements to the console in a Spring Boot application using Logback?

# Example Logback configuration to suppress Hibernate SQL logging
<configuration>
  <logger name="org.hibernate.SQL" level="WARN"/>
  <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="WARN"/>
</configuration>

When working with a Spring Boot application that uses Hibernate as the ORM (Object-Relational Mapping) tool, you might find that SQL statements are logged to the console by default. While this can be useful for debugging purposes, it can also clutter your logs and affect performance. In this guide, we'll explore how to suppress these SQL logging statements using Logback.

# logback-spring.xml configuration to disable Hibernate SQL logging:
<configuration>
  <logger name="org.hibernate.SQL" level="WARN"/>
  <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="WARN"/>
</configuration>

Causes

• Hibernate is configured to log SQL statements at the INFO or DEBUG level.
• Logback retains default logging settings which capture these log levels.

Solutions

• Modify the Logback configuration to adjust the logging level for the Hibernate SQL logger.
• Set specific Hibernate properties to reduce or eliminate SQL logging.

Mistake: Forgetting to include the logback-spring.xml configuration file in the resources folder.

Solution: Ensure that the logback-spring.xml file is located in the src/main/resources directory.

Mistake: Not restarting the Spring Boot application after making changes to the logging configuration.

Solution: Always restart your application to apply changes in the logging configuration.