Fwd: [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB
FYI: my email exchange with PostgreSQL folks regarding BLOB mapping
to PostgreSQL "bytea" type. They recommend using "oid" instead.
Anyone has experience with PostgreSQL oids as BLOBs?
Begin forwarded message:
> From: Andrus Adamchik
> Date: August 1, 2005 7:35:15 PM GMT+04:00
> To: Kris Jurka
> Subject: Re: [JDBC] BUG #1780: JDBC driver "setNull" throws for
> BLOB and CLOB
>> You need to use
>> oid as the underlying type, or if you want to use bytea you need
>> to use
>> setBytes or setNull(x, Types.BINARY).
> I suspected that this problem could be due to our misinterpretation
> of PostgreSQL data types. "bytea" seemed the closest thing to BLOB,
> and it worked like one in almost all of our tests. But I'll give
> oid a try.