After reading the posts from the previous days regarding blobs I unpacked the demos in %ORACLE_HOME%/jdbc, compiled and ran them all (some required minor modifications in order to work with JDBC2.0, e.g. classes12.zip).
The LobExample.java in oci8\object-samples demonstrates how to read/write BLOBs and CLOBs, using Oracle's proprietary BLOB and CLOB classes, of course (that's the big gotcha). The readme states, that all examples in oci8 work with the thin driver as well. At least on my windows box I could verify this. My own interest is: I want to be able to store arbitrary documents in the Oracle DB using EJBs (instead of storing them in the file system). 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. They also have a PL/SQL-based sample for accessing (B/C)LOB data. Regards Georg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sacha Labourey Sent: Monday, May 20, 2002 12:30 To: [EMAIL PROTECTED] Subject: RE: [JBoss-dev] CMP2.0 and CLOB: same as JAWS Hello Georg, > Besides being not as standards compliant as one would wish them to be, > the Oracle thin drivers have always been working like a breeze for me. OK. So, do you have some information regarding CLOB in Oracle and how to best handle them with thin drivers? This could be useful. 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 _______________________________________________________________ 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
