Postgres driver converting null bind values to Byte array

From: Karthik K L V <venkata(dot)karthik4u(at)gmail(dot)com>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Postgres driver converting null bind values to Byte array
Date: 2022-07-20 16:43:16
Message-ID: CAGpQzhxQDeauYxru6dZbgrbth3KgJpNqQ8Y0yr0ZHO=HJHYcvA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

Appreciate your help.
Thank you.

--
Karthik klv

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2022-07-20 19:07:02 Re: Postgres driver converting null bind values to Byte array
Previous Message Dave Cramer 2022-07-19 17:02:13 [pgjdbc/pgjdbc] a18028: deploy: 803d8d33267f3429659900bb0c39a10a1db6545e