Question mark in native query

[kubav182]

When working with jsonb type in postgres, we can use ? operator.

SELECT * FROM table WHERE (json_col->'jsonKey')::jsonb ? :param

In JDBC driver you can use escape sequence ??
In Hibernate you can use escape sequence \\?\\?

But what should I use in Spring Data JPA? I'm getting error during startup java.lang.IllegalArgumentException: Mixing of ? parameters and other forms like ?1 is not supported!

I'm using Spring Boot 2.4.5

[schauder]

This sounds like it needs fixing on our side. Could you provide a demonstrator, including the database using testcontainers, please?

[kubav182]

https://github.com/kubav182/demo-spring-data-jpa-question-mark

There is demo with working JPA and JDBC implementations. Data JPA implementation does not work and test fails.

[gregturn]

Thanks @kubav182. I've reproduced it on my end with a very simple unit test.