1. The purpose of this post
This demo show how to print SQL logs of your dao when using springboot apps.
2. Environments
- SpringBoot 1.x and 2.x
- Java 1.8+
3. JPA solution
Just add this to your application.properties
spring.jpa.show-sql=true
Then you would get this:
Hibernate: select student0_.id as id1_0_, student0_.branch as branch2_0_, student0_.email as email3_0_, student0_.name as name4_0_, student0_.percentage as percenta5_0_, student0_.phone as phone6_0_ from tbl_student student0_ limit ?
You can find detail document of this settings in Data Access of SpringBoot Reference.
4. JdbcTemplate solution
Just add this to your application.properties
logging.level.=ERROR
#or
logging.level.org.springframework.jdbc.core = TRACE
#or
logging.level.org.springframework.jdbc.core.JdbcTemplate=DEBUG
Then you would get this:
2019-05-11 12:11:10.708 DEBUG 8852 --- [nio-8080-exec-1] o.s.jdbc.core.JdbcTemplate