Thomas,
> > According to JDBC 3.0 specifiction, those 4 methods may not be
> > compatible to BLOB/CLOB. Some databases may support them to
> access LOB
> > data but not all databases.
> >
> 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.
Also, there were some limitations with Oracle JDBC "Thin" driver 9.2 and those methods didn't work
with LOB.
Thanks,
ebi