Postgres driver converting null bind values to Byte array

Поиск
Список
Период
Сортировка
От Karthik K L V
Тема Postgres driver converting null bind values to Byte array
Дата
Msg-id CAGpQzhxQDeauYxru6dZbgrbth3KgJpNqQ8Y0yr0ZHO=HJHYcvA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres driver converting null bind values to Byte array
Список 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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: [pgjdbc/pgjdbc] a18028: deploy: 803d8d33267f3429659900bb0c39a10a1db6545e
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Postgres driver converting null bind values to Byte array