[SPRING] How to pass a list of tuples to a IN clause using NamedParameterJdbcTemplate

December 8, 2020 less than 1 minute read

I’d like to share something I recently came across that I think is little known (or at least I didn’t find it in the documentation 😅)

I was working on a jdbc-related @Component and needed a IN clause with multiple tuples. A IN with multiple tuples is something like this:

SELECT * FROM MY_TABLE
 WHERE (COL_1, COL_2, COL_3)
    IN (('AAA', 111, 'X'), ('BBB', 222, 'Y'))

While I was coding I had a doubt: is the NamedParameterJdbcTemplate able to handle it? Fortunately, yes, it does! How? The answer is more trivial than expected!

Read More →