Update: Followed this thread PostgreSQL: Re: Null bind variable in where clause <https://www.postgresql.org/message-id/4906DD3E-322A-4E26-8600-B967AFA8A58F%40fastcrypt.com>
and set *transform_null_equals to ON* in the parameter group on the AWS Console. But no luck. We are using Aurora PostgresSQL v13.3 On Wed, Jul 20, 2022 at 3:02 PM Karthik K L V <venkata.karthi...@gmail.com> wrote: > 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 > -- Karthik klv
