I am facing the below issue while executing a query in Aurora Postgres SQL 13.2 from java application using Spring Data JPA and Hibernate.
The query works perfectly fine when the value of the bind variable gets resolved to some value but fails with the below exception when the same bind value gets resolved to null from the java application.
Exception:
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bytea Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 1037
The value of the bind variable is sent as String from the application and the Datatype of the corresponding Column is Text.
Here are the version details.
1. JAVA: 11
2. Postgres Driver: postgresql-42.3.5.jar
3. Server: Aurora Postgres 13.2
4. Executing a prepared statement with Bind values resolved at runtime.
Could you please let me know if there is any property available on the Postgres driver which can be configured to avoid converting null object values to Byte array?