Hi,

I have a table with ByteA column (varbinary, binary, blob) in PostgreSQL. When I try to insert something in that table I have the following error:

org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: ERROR: column "medium_image" is of type bytea but expression is of type oid

In current case the value of that column is NULL.

How can I solve that problem? If I have pure JDBC statement I know what to do, but I don't know what to do when Hibernate works with JDBC.


Regards,
Miro.

I try with
<property name="hibernate.jdbc.use_streams_for_binary" value="false"/>
then with "true", but without result.


Miro.

Hi,
I had the same problem and resolve it by changing the column type from bytea to oid.
More information here: http://jdbc.postgresql.org/documentatio ... -data.html