Spring enable SQL logs in application.yml

Question

I'm building a spring boot application. I'm trying to enable SQL logs in application.yml. How can I do it?

Does this answer your question? [How to log SQL statements in Spring Boot?](https://stackoverflow.com/questions/30118683/how-to-log-sql-statements-in-spring-boot) — Pirate, Jun 18 '21 at 06:45

score 1 · Accepted Answer · answered Jun 18 '21 at 07:25

1

We can use any one of these:

spring:
  jpa:
    show_sql: true

or

logging:
  level:
    org:
    hibernate:
        sql=debug
        type:
        descriptor:
            sql:trace

answered Jun 18 '21 at 07:25

Drashti Dobariya

1 Answers1