Skip to main content

How to enable SQL logs in Spring Boot application?

Image
By

This tutorial will demonstrate how to enable and disable SQL log statements in a Spring Boot application in order to debug SQL flow.


Problem

You will frequently need to debug the SQL statement while developing a Spring Boot application with a SQL database.

SQL debug logs can assist you figure out what's wrong with JPA statements and whether or not there's a problem with database connectivity.

Example 

If you've built custom Spring data JPA methods and need to know what SQL statement is being utilized behind them,

return repository.findByUsernameIn(usernames);

Then you can enable Hibernet debug mode to log SQL statements.

Solution

Update the application.yml file with the Hibernet configuration as

logging:
  level:
    org:
      hibernate: DEBUG

or application.properties as

logging.level.org.hibernate=DEBUG


The SQL statement will appear in the application logs after modifying the configuration file and restarting the application.

2022-04-07 08:41:45.118 DEBUG 14561 --- [nio-8080-exec-1] org.hibernate.SQL                        : 
select user0_.id as id1_0_, user0_.password as password2_0_, user0_.username as username3_0_ from user user0_ where user0_.username in (?)


Spring Boot Profiles

This setup is great for debugging and testing your application while you are building or improving its features, but it's not appropriate for staging or production situations.

To turn off the debugging logs in the production environment, you should prefer to use Spring boot profiles.

  • application.properties :            Local machine
  • application-dev.properties:      Development environment.
  • application-stage.properties:   Stage/Test environment
  • application-prod.properties:    Production environment 

Inside application-prod.properties, specifically turn off SQL debug logs, like

logging.level.org.hibernate=OFF

Note: It is not a rule to name your application properties file as mentioned in this tutorial. You are free to give it whatever name you like.

Conclusion

SQL debugging can be activated or deactivated by application configuration. The production environment should explicitly disable this configuration.

You can access tutorial code from Github page.

Labels:

Comments

Post a Comment

Subscribe for latest tutorial updates

* indicates required

Popular posts from this blog

Preload Images Using Javascript

By
Preload Image is technique which helps browser to render images with minimum delay. Today we will see example of image gallery. Gallery contain 5 images which load images one after another whenever user clicks next and back button. This is a basic image gallery scenario which is used in all possible website, then why we need preloaded images for this gallery? Now a day’s most of website becoming faster and user expectation is increasing. Suppose your website doesn’t use preload image technique for gallery and a user visits any image gallery from Google Plus or Facebook and visits your website gallery. Then that user always prefer those websites rather than yours. Why? Because your website load one image at a time. When user click on next button, then only gallery load image and user has wait till it get loaded. To avoid this situation gallery needs to download all images
Post a Comment
Read more

Spring Boot RestTemplate Guide with Example

By
What is RestTemplet? RestTemplate is a HTTP Client library that provides basic APIs for executing different HTTP type requests. RestTemplate is one of the HTTP libraries available on the market. The Spring Boot team designed and maintains it. As previously said, it is a client library, which means it may be utilised in our application as a stand-alone dependency. To utilise it, you don't require a complete Spring boot application. It's suitable for use in simple Java applications as well as other frameworks such as Micronaut, Play and others. Setup Add RestTemplate dependency to project, for this tutorial I am creating a simple java application to consume HTTP request and a node application to provide HTTP service. For Gradle build tool Add the following dependency in the build.gradle file . // https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-web implementation group: 'org.springframework.boot' , name: 'spring-boot-starter-w
Post a Comment
Read more

CSS: How To Create Custom Scrollbar For Webkit Supported Browsers

By
In this tutorial, we will learn how to create a custom scroll bar using custom CSS styles. Custom scrollbars are becoming increasingly popular, and I'm excited to learn more about them. A scrollbar can be customised for a variety of reasons. The default scrollbar, for example, can make an app's UI look inconsistent across various versions of windows, thus we can benefit from having a single style here. This tutorial will help to create a custom scrollbar. Let's see how One of the most interesting aspects of these scrollbars is that they may be rendered in a variety of styles for different HTML elements on the same webpage. We will see the implementation of such a scrollbar for Webkit-supported browsers. First we will look at the basic CSS properties of the scrollbar. ::-webkit-scrollbar              ::-webkit-scrollbar-thumb        ::-webkit-scrollbar-track        ::-webkit-scrollbar-button       ::-webkit-scrollbar-track-piece  ::-webkit-scrollbar-cor
Post a Comment
Read more