Wouter Veltmaat wrote:
I'm willing to vote for everybody who's willing to actively support some kind of database.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 activelyExcuse me, but isn't open source 'scratch your own itch'. If you need support for db2, mssqlserver, or whatever database you'd like to use, please add support for it. We've tried to add Oracle support, but without somebody who uses oracle, knows oracle, etc it's allmost impossible to get good support for it.
while it over a year ago it was commited in a meeting to do so. (Same goes
for DB2 and MS SQL server)
It's allready very difficult to test every MMBase version before releasing it with all the databases, application servers, jdk's, os, etc that are being used in the community.....
I don't say I'm not interested in support for other databases, but we have to have active maintainers. Without them, you can add support for one database, but it will never be tested or fixed again if something is broken.
Still I don't think it makes sense to use MMBaseOk, I agree with some database it would be great if MMBase uses some database-specific options, and iirc the database search project is creating an api to get that far.
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 think there are other databases that are being used, like postgresql, hsqldb, informix. So I would advice to *not* use mysql.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.
We will support every database that exists in this world, only if we would have maintainers for them....it's not easy to test every database........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
I don't agree it's being dropped, it has been discussed. Gerard
