NamedParameterJdbcTemplate doesn't support postgresql dollar quoting $$ [SPR-16512]

[spring-projects-issues]

RJ opened SPR-16512 and commented

When trying to use valid postgresql dollar quoting syntax, NamedParameterJDBCTemplate thinks that the dollarquote is a named param and fails b/c no value is given.

A query like:

select * from a where a.col1 = $ranS58$value$ranS58$;

throws the error:

org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'value$ranS58$':

---

Affects: 4.3.14

Issue Links:

• NamedParameterJdbcTemplate fails on PostgreSQL array [SPR-16340] #20887 NamedParameterJdbcTemplate fails on PostgreSQL array
• Spring JDBC not correctly processing Postgresql ? operator [SPR-16511] #21054 Spring JDBC not correctly processing Postgresql ? operator