Thread: Postgres driver converting null bind values to Byte array
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
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
On Wed, 20 Jul 2022 at 12:43, Karthik K L V <venkata.karthik4u@gmail.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: 1037The 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: 112. Postgres Driver: postgresql-42.3.5.jar3. Server: Aurora Postgres 13.24. 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
Hi Dave,
We are using Spring Data JPA and Hibernate framework and passing the bind value as a String from the java code.
So the framework should be using the setString() method internally if I am not wrong.
On Thu, Jul 21, 2022 at 12:37 AM Dave Cramer <davecramer@postgres.rocks> wrote:
On Wed, 20 Jul 2022 at 12:43, Karthik K L V <venkata.karthik4u@gmail.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: 1037The 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: 112. Postgres Driver: postgresql-42.3.5.jar3. Server: Aurora Postgres 13.24. 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 Cramerwww.postgres.rocksAppreciate your help.Thank you.--Karthik klv
Karthik klv