No logging happens for jdbc in springboot-CodePudding

In my application.properties I have

log4j.category.org.springframework.jdbc.core = TRACE
log4j.logger.org.springframework.jdbc=DEBUG

and the below dependencies in my pom.xml:

 <dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter</artifactId>
  <exclusions>
    <exclusion>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-logging</artifactId>
    </exclusion>
  </exclusions>
</dependency>
<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-log4j2</artifactId>
</dependency>

But no logging happens for jdbc statements, although my main application's INFO level logs are appearing. What could cause this?

CodePudding user response：

To configure log levels in Spring Boot, you should use properties with the form logging.level.<logger-name>=<level>. For your two loggers, the properties should be:

logging.level.org.springframework.jdbc.core=TRACE
logging.level.org.springframework.jdbc=DEBUG

You can learn more in the relevant section of the Spring Boot reference documentation.