FYI, I did fix the Oracle LOB issues a very long time ago. As well as create an automated sequence for primairy keys. But due to lack of support and masses of dirty code (before the cleaning project) I stopped working on it. There simply wasn't any support from others to help out with the Oracle part. At that time MMBase was too much MySQL specific to get correctly working with another database. And to this day Oracle support has been minimal and almost non existent besides the MMOracle class file that Daniel wrote. And now Rob seems to have invented the wheel yet again.
Still since the Oracle libraries aren't open source it's impossible to include them in the default build file. But I think support for this should be available in the build script. Just like Rob van Maris mentioned. But I don't think there will be enough votes for this since I don't think anyone actively will support fixing Oracle related issues. (Kudos to Rob since he at least is open for suggestions) I think it's remarkable that MMBase doesn't really support Oracle actively while it over a year ago it was commited in a meeting to do so. (Same goes for DB2 and MS SQL server) Still I don't think it makes sense to use MMBase on Oracle. Since it only uses tables and not the many options like record locking, sequences, triggers and advanced transactions you would use normally on a Oracle database. I even wouldn't advise using Oracle as database with MMBase. I rather would use MySQL since it's been built and tested on MySQL by majority of the developers. If you have to use Oracle pers� I would advise to use the Oracle application server together with it's developer environment. I don't think MMBase will work well together with Oracle database ever because the developers won't support it. (It works just fine on Oracle Application server, which is just an adapted/enhanced version or Orion application server) Sincerely, Wouter Veltmaat ps. I know this is flame material, but Rob has made a decent suggestion which is dropped with excuses for arguments > -----Oorspronkelijk bericht----- > Van: Rob van Maris [mailto:r.van.maris@;vpro.nl] > Verzonden: vrijdag 8 november 2002 13:41 > Aan: MMBase developers > Onderwerp: Improving support for Oracle > > > I'm putting some effort into improving MMOracle.java, based on our own > experiences and suggestions from others. > A problem that comes up is that some proprietary Oracle > classes are needed > to read data from large objects. > > Consequently, if I modify MMOracle.java, it can no longer be compiled > without the Oracle classes. Since we can't distribute the > Oracle classes > with MMBase, this means we can provide the MMOracle.java > sourcefile, but > can't include it in the standard compile targets. > > I suggest we adapt the build script so that MMOracle is > compiled only when > the oracle classes are detected in the classpath. > > On a related note, currently all *.jar files in the lib directory are > included in the classpath. It makes sense to extend this to > include all > *.zip as well. For example, the Oracle jdbc driver is shipped > as a zip-file > instead of a jar. > > I can make these changes myself, but I would prefer > modifications to the > build script being more centralized. > > Rob van Maris > Developer > > Finalist IT Group > Java Specialists > ------------------------------------------------------------- > Amsterdam, The Netherlands > Office: +31 20 5962321 (Direct) > Mobile: +31 651444006 > Fax: +31 20 5962331 > ------------------------------------------------------------- > > >
