spring boot could show sql even use JdbcTemplate directly

spring-boot jdbctemplate
zhuguowei picture zhuguowei · Mar 8, 2016 · Viewed 9.2k times · Source

spring boot project, used JdbcTemplate, and want to show sql which is executed, the configuration is as below

spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true

but nothing output, it seems above configuration only support spring data jpa, So I'd like to know does exist some manner could show sql even used JdbcTemplate directly?

Answer

Stephane Nicoll picture Stephane Nicoll · Mar 8, 2016

There is a reason why the property is named spring.jpa something: it is to indicate you that it relates to JPA in some form.

If you're using JdbcTemplate, you're not using JPA hence that property can't have any effect. You can enable logging for the org.springframework.jdbc.core.JdbcTemplate class

logging.level.org.springframework.jdbc.core.JdbcTemplate=debug

Related questions

Spring Boot: Jdbc javax.net.ssl.SSLException: closing inbound before receiving peer's close_notify

I am currently learning more about implementing JDBC and using databases in a Spring Boot webapp, and I encountered the following Stack Trace written in the bottom of the post. I have created a simple Employee model, and I am …

Read More
Multiple DataSource and JdbcTemplate in Spring Boot (> 1.1.0)

I would like to inject a specific JdbcTemplatein a Spring Boot project. I tried to follow this example for multiple DataSourceconfiguration : http://spring.io/blog/2014/05/27/spring-boot-1-1-0-m2-available-now My code does compile and run, but only the DataSource …

Read More
Roll back A if B goes wrong. spring boot, jdbctemplate

I have a method, 'databaseChanges', which call 2 operations: A, B in iterative way. 'A' first, 'B' last. 'A' & 'B' can be Create, Update Delete functionalities in my persistent storage, Oracle Database 11g. Let's say, 'A' update a record in …

Read More