Re: operator does not exist: text = bytea

Hi Team,

I am getting the below error while executing a Select query using Spring DataJPA and Hibernate framework in Aurora Postgres SQL.

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

We have a query with bind value which sometimes gets resolved to null (no data) depending on the application scenario.

The datatype of the bindvalue and the corresponding column is String.

The same query executes fine when the value of the bindvalue is populated.

Could you please let me know how I can resolve this issue without making changes to the query? 

Is there any configuration available in the Postgres Driver or on the Postgres DB Server which can be set to resolve null bind values?

Appreciate your help. Thank you.

--

Karthik klv