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?
Andrus
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
>
>
> Kris,
>
>> 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.
>
> Thanks
> Andrus
This archive was generated by hypermail 2.0.0 : Mon Aug 01 2005 - 11:38:06 EDT