Spring JDBC not correctly processing Postgresql ? operator [SPR-16511]

[spring-projects-issues]

RJ opened SPR-16511 and commented

When running the following valid postgresql:

select '{"a":1, "b":2}'::jsonb ? ':1';

I get the error ```
Not allowed to mix named and traditional ? placeholders.

related to #19945 and #18159

---

Affects: 4.3.14

Issue Links:

• Spring JDBC not correctly processing Postgresql ?-contained operator [SPR-13582] #18159 Spring JDBC not correctly processing Postgresql ?-contained operator
• Spring JDBC not correctly processing Postgresql ?| and ?& operator [SPR-15382] #19945 Spring JDBC not correctly processing Postgresql ?| and ?& operator
• NamedParameterJdbcTemplate doesn't support postgresql dollar quoting $$ [SPR-16512] #21055 NamedParameterJdbcTemplate doesn't support postgresql dollar quoting $$

[spring-projects-issues]

RJ commented

this can be closed.

escaping the '?' w/ a '?' as described in the docs works as expected