0

I am trying to log my SQL queries using p6spy. I am using spring-boot 2.7.9. I am using the spring-boot-data-source-decorator.

I have added the dependency as mentioned in the README.

NFO] |  +- org.springframework:spring-tx:jar:5.3.25:compile
[INFO] |  +- com.github.gavlyukovskiy:p6spy-spring-boot-starter:jar:1.8.0:compile
[INFO] |  |  +- com.github.gavlyukovskiy:datasource-decorator-spring-boot-autoconfigure:jar:1.8.0:compile
[INFO] |  |  \- p6spy:p6spy:jar:3.9.0:compile
[INFO] |  \- org.springframework.boot:spring-boot-starter-jooq:jar:2.7.9:compile
[INFO] |     \- jakarta.activation:jakarta.activation-api:jar:1.2.2:compile

Also added the below settings in my application.properties.

decorator.datasource.p6spy.enable-logging=true
decorator.datasource.p6spy.multiline=true
decorator.datasource.p6spy.logging=sysout

I am still not seeing the SQL Query logs in the console. Can someone suggest what is going wrong?

tuk
  • 5,941
  • 14
  • 79
  • 162

0 Answers0