Hello,

> I would post the code here, but I'm not sure whether Oracle's license
> puts any restriction on publishing
> their demo code. Basically they use their BLOB and CLOB classes and
> getCharacterStream()/getBinaryStream()
> to read the data, and getCharacterOutputStream()/getBinaryOutputStream()
> to write the data.

OK, but their readme file for driver v8.1.7 and v9.0.1 indicates that
calling getCharacterOutputStream (CLOB) will only work with OCI, not Thin =>
the only solution is to use setClob passing an instance of oracle.sql.Clob.
Passing a class implementing java.sql.Clob results in a ClassCastException
in Oracle's code...

Calling getCharacterOutputStream and passing the string *will* work with the
THIN driver *only* with small strings (<2k I guess). With bigger string, it
will fail. Are you sure you've succedded your tests with *big* strings?

But I agree, we will have to put some Oracle (or any other db) specific code
in some cases. BEA WL, for example, has the support (in its
PreparedStatement interface) for setClob *and* setCLOB. This last being an
*oracle* specific method because it wants an Oracle CLOB object, not a
simple object implementing java.sql.Clob!...

Cheers,



                                Sacha


_______________________________________________________________
Hundreds of nodes, one monster rendering program.
Now that's a super model! Visit http://clustering.foundries.sf.net/

_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to