So currently the only way to persist binary data like office documents in an Oracle DB using JBoss is to write an Oracle-specific EB with BMP?
(The generic version using the standard JDBC2.0 API should still work with Oracle 8.1.6 or above and OCI. Using OCI should not be a problem in the usual application server setting. It has other advantages like not bypassing the Oracle Name Server). Anyway: thanks for listening. Georg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dain Sundstrom Sent: Monday, May 20, 2002 19:04 To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] CMP2.0 and CLOB: same as JAWS Georg, I agree with David on this. The proper place to do this type of optimizations is in the JCA wrapper. My goal moving to 4.0 is to try to make the CMP engine more generic to the point where it can persist to any JCA connection. At the same time we would introduce DB specific JCA wrappers to optimize calls, map queries, unwrap SQLExceptions, and other cool features like these. In the mean time, you will have to accept the fact that JBossCMP will have restrictions on what can be done. -dain Georg Schmid wrote: > 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. > > Most of the people that would be willing to pay for JBoss support will > be exactly those who are using Oracle. > > As you dig deeper into the database-related issues, you will notice, > that you need to handle proprietary APIs and extensions not only with > Oracle (you already do it in the type mapping). > > The main reason for this is that in a project that has to handle large > amounts of data all the performance features offered by the database > have to be exploited in the utmost way. > And this cannot (yet) be accomplished through a generic interface. > > That's of course very inconvenient because not all of the JBoss code > will compile always and everywhere anymore. To get it done in a > orderely fashion, you will need a kind of plugin interface sooner or > later. > > Maybe one could do something like the optional tasks in ant. If you > copy your Oracle classes12.zip into an "cmp/optional" directory, the > Oracle extensions will be compiled in, otherwise > you only get the vanilla support (for instance, no or only half-working > (C)LOBs). > > I guess it's like writing a 3D gaming engine. You have to detect what > the graphics card supports, use the features that are available > (otherwise your users will complain about the performance) > and gracefule degradate, if they are missing. > > Georg > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Sacha Labourey > Sent: Monday, May 20, 2002 08:46 > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-dev] CMP2.0 and CLOB: same as JAWS > > > Hello Dain, > > >>Besides Oracle's drivers being a crap, >> > > for sure, yes. > > >>the CLOB and all SQL 99 types >>could use improvement. Supposedly Oracle's new 9.0.2 drivers fix most >> > >>of these problems. Fixing general Object persistence is the first >>think >> > > Great. > > >>I will be working on after I finish the docs (this week), so I will >>look at this then. I am even planing on putting a hack in just for >>Oracle's BLOB problems, so I can also put one in for CLOBS. Normally >>I wouldn't put a hack in for a vendor but Oracle it to huge. The flag >> > >>of this option will be some thing <oracle-sucks-and-i-use-it>. =) >> > > OK, if you need some testing (or more accurate details on the problems > I found), just tell me: I have a CMP and its associated Oracle DB that > are already ready for testing. > > 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 _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
