From: | Karthik K L V <venkata(dot)karthik4u(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | operator does not exist: text = bytea |
Date: | 2022-07-20 09:32:13 |
Message-ID: | CAGpQzhyp+Jfvz1BveXupEzw48gofzwy=xHW143z50ouJHu-4jw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2022-07-20 09:33:25 | Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence |
Previous Message | Sebastien Flaesch | 2022-07-20 09:15:29 | Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence |