How to log SQL statements with query param values in Spring Boot 3/Hibernate 6

Question

I recently upgraded my Spring Boot app to v3.0 which required Hibernate to be upgraded to v6.1.5.Final.

I'm using Spring Data JPA with Hibernate as the JPA provider. When I run the app locally, I want to log SQL statements and the values of any parameters in those statements. To this end, I've added the following to my local configuration, as per this blog post:

spring:
  jpa:
    show-sql: false
    properties:
      hibernate:
        format_sql: true
logging:
  level:
    org.hibernate.SQL: debug
    org.hibernate.type.descriptor.sql: trace

I'm pretty sure this worked prior to the upgrade, but now only the SQL statements are logged i.e. the parameter values are missing.

Is it possible to log the query parameter values when using Spring Boot v3.0 and Hibernate v6.1.5.Final?

Try adding this to your application.properties logging.level.org.hibernate.type.descriptor.sql.BasicBinder=trace — Saif Ahmad
– Saif Ahmad, Commented Dec 20, 2022 at 11:41

Dirk Deyne · Accepted Answer · 2022-12-20 12:15:58Z

40

Logging SQL in Spring boot 3 with Hibernate 6:

logging.level.sql for SQL logging group including Hibernate SQL logger.
logging.level.org.hibernate.orm.jdbc.bind for showing the binding parameters

So this should work:

logging:
  level:
    sql: debug
    org.hibernate.orm.jdbc.bind: trace

answered Dec 20, 2022 at 12:15

Dirk Deyne

6,9961 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Aspiring Dev 23000 Over a year ago

in my case i had to set the logging.level.root to TRACE for this to work, which opened the gates for all types of TRACE level logs, how can i avoid this ? @Dirk Deyne

Aspiring Dev 23000 Over a year ago

here's my application.yml : logging: level: org: hibernate: orm: jdcb: bind: TRACE sql: DEBUG root: TRACE

Dirk Deyne Over a year ago

@Abdou changing the root logging level will not change the output of the other logging levels.

Penny Liu · Accepted Answer · 2024-09-14 12:53:10Z

2

These properties also work with spring boot version 3.x.x

logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.orm.jdbc.bind=TRACE

edited Sep 14, 2024 at 12:53

Penny Liu

17.9k5 gold badges89 silver badges109 bronze badges

answered Aug 31, 2023 at 8:55

Francis

6431 gold badge6 silver badges17 bronze badges

Comments

CPPUIX · Accepted Answer · 2025-05-18 23:22:03Z

1

This line in the application.properties is enough with Spring Boot 3.4.5 and Hibernate 6.

logging.level.org.hibernate.orm.jdbc.bind=TRACE

edited May 18 at 23:22

CPPUIX

2,4178 gold badges17 silver badges38 bronze badges

answered May 15 at 18:52

Jimmy Cumbicos

112 bronze badges

Collectives™ on Stack Overflow

How to log SQL statements with query param values in Spring Boot 3/Hibernate 6

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related