> On Sep 5, 2022, at 23:10, Karthik K L V <venkata.karthi...@gmail.com> wrote:
> The above query fails with the below exception when the value of ?1 resolves
> to null.
> org.postgresql.util.PSQLException: ERROR: operator does not exist: character
> varying = bytea
> Hint: No operator matches the given name and argument types. You might need
> to add explicit type casts.
> Position: 64
This is a Hibernate issue. If you use setParameter with a NULL without
specifying the type, it assumes bytea (with the PostgreSQL JDBC driver, at
least). You'll need to use the three-parameter form of setParameter() that
specifies a type, if the value is going to be NULL. You can also use the
setXXXX methods on SQLQuery, since the type is specified by the particular
method there.
That being said, PostgreSQL's handling of NULL string values is different from
Oracle's, and this is an area that code changes are often required.
