[FIXED] Log values of query parameters in Spring Data R2DBC?

Issue

In Spring Data R2DBC I can log SQL queries by using

logging.level.org.springframework.data.r2dbc=DEBUG

in the application.properties.

However, this doesn't log the actual values that are bound as query parameters.

How can I log the actual values of query parameters in Spring Data R2DBC?

Solution

This worked for me :

 logging:
  level:
    io.r2dbc.postgresql.QUERY: DEBUG # for queries
    io.r2dbc.postgresql.PARAM: DEBUG # for parameters

I found it here

Answered By - b.khalsi
Answer Checked By - Mildred Charles (JavaFixing Admin)