> On Sep 5, 2022, at 23:10, Karthik K L V <venkata.karthik4u@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
PostgreSQLJDBC driver, at least). You'll need to use the three-parameter form of setParameter() that specifies a type,
ifthe value is going to be NULL. You can also use the setXXXX methods on SQLQuery, since the type is specified by the
particularmethod there.
That being said, PostgreSQL's handling of NULL string values is different from Oracle's, and this is an area that code
changesare often required.