| 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
| 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 |