From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: standard LOB support |
Date: | 2007-06-22 07:44:39 |
Message-ID: | f5ful6$am$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joost Kraaijeveld | 2007-06-22 07:59:24 | Can I backup/restore a database in a sql script? |
Previous Message | EBIHARA, Yuichiro | 2007-06-22 07:28:25 | Re: standard LOB support |
From | Date | Subject | |
---|---|---|---|
Next Message | EBIHARA, Yuichiro | 2007-06-22 08:20:54 | Re: standard LOB support |
Previous Message | EBIHARA, Yuichiro | 2007-06-22 07:28:25 | Re: standard LOB support |