Fwd: [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Fwd: [JDBC] BUG #1780: JDBC driver "setNull" throws for BLOB and CLOB

Andrus Adamchik
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