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