Use logback to log sql parameters of spring JdbcTemplate

Question

I'm using Logback with Spring JdbcTemplate to log my SQL queries. My configurations contains next line:

<logger name="org.springframework.jdbc.core.JdbcTemplate" level="DEBUG" />

But this logs only query with wildcards ? without list of parameters.

Here on SO I found a few answers how to achieve parameters logging with log4j. But I don't want to switch to log4j.

So how can I receive parameters list for JdbcTemplate with Logback?

Edit

Actually, I'm using NamedParameterJdbcTemplate, if it matters.

Answer 1

Try this

<logger name="org.springframework.jdbc.core.StatementCreatorUtils" level="TRACE" />

this will show log:

Setting SQL statement parameter value: column index 1, parameter value [1234], value class [java.lang.Integer], SQL type unknown

Answer 2

I usually prefer handling SQL statement logging at the DataSource or JDBC driver level.

I use BoneCP DataSource/Connection Pool library, which include support for statement logging via SLF4J and many other usefull features.

If changing your DataSource/Connection Pool library is not an option, maybe you can use log4jdbc which works as a proxy jdbc driver, which logs statements to SLF4J before calling the actual jdbc driver that talks to the database.