Thomas,
Thank you for your comment.
> I found that using getBinaryStream(), setBinaryStream(),
> getCharacterStream()
> and setCharacterStream() to handle LOBs across different DBMS
> is much more
> portable (and reliably) than using the Clob()/Blob() methods.
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.
But my target databases are, actually, only PostgreSQL, Oracle and DB2 and
there is no problem with
PostgreSQL.
Also, according to the Oracle JDBC driver manual, Oracle supports stream access
to LOB through the 4
methods.
I'll also try DB2 soon.
Thanks,
ebi
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
