Re: Search content within a bytea field

Florian Weimer wrote:
> * Kris Jurka:
>
>> Use setObject(int, object, Types.OTHER);
>
> I get a PSQLException with "Cannot cast an instance of
> java.lang.String to type Types.OTHER".  Other types (such as Integer)
> don't work, either.
>
> I look rather hard at Debian's 8.2-504-3 source but couldn't find a
> straightforward way to make this work, beyond specifying
> stringtype=unspecified for the whole connection.
>

This is new functionality in 8.3 and newer drivers.

Kris Jurka