Re: standard LOB support

EBIHARA, Yuichiro wrote on 22.06.2007 09:28:
>> Hmm. At least for updating LOBs, "my method" should be
>> "legal". This is a quote from jdbc-3_0-fr-spec.pdf
>>
>> "The setBinaryStream and setObject methods may also be used
>> to set a Blob object as a parameter in a PreparedStatement
>> object. The setAsciiStream, setCharacterStream, and setObject
>> methods are alternate means of setting a Clob object as a parameter."
>
> Sorry, my comment was partially incorrect.
> See B-182(TABLE B-6) of the spec.
> getBinaryStream()/getCharacterStream are not compatible to LOB.
Thanks for the pointer ;)

According to that table, the PG driver is actually correct, as bytea is reported
as Types.BINARY not Types.BLOB

> Also, there were some limitations with Oracle JDBC "Thin" driver 9.2 and those methods didn't work
> with LOB.
Yes I found that as well. Only the 10.x driver work correctly

Regards
Thomas