I'll say it again, the place for special purpose vendor-dependent code like this is in a vendor-specific jca-jdbc wrapper.
Are you guys talking local or xa transactions? david jencks On 2002.05.20 07:39:04 -0400 Georg Schmid wrote: > > 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 > > _______________________________________________________________ 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
