Re: Postgres driver converting null bind values to Byte array

On Wed, 20 Jul 2022 at 12:43, Karthik K L V <venkata(dot)karthik4u(at)gmail(dot)com>
wrote:

> Hi Team,
>
> 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?
>

I'm guessing you are using setObject ?
It would be helpful to see the type mapping

Dave Cramer
www.postgres.rocks

>
> Appreciate your help.
> Thank you.
>
>
> --
> Karthik klv
>