Ports of RDBMS store to other DBs

[Oliver Zeigermann]

Tests have shown the RDBMS store in the proposals section is at least 
not worse than previous versions of stores working on DBs and also not 
worse than the tx file store. Also, the *general* databse schema (which 
basicly has been taken over from Ashoks contribution) is not supposed to 
change any more.

Thanks to Christophe we already have a port to MySQL. My port to Oracle 
gets really tricky, bcause:
1. There is a bug or at least "a special feature" in DBCP that 
effectively does not allow to change the isolation level. I reported 
this to the commons list. Let's see if it gets any attention.
2. Different from other DBs Orcale has no AUTO_INCREMENT or IDENTITY or 
anything directly comparable to these, but uses sequences. This may mean 
quite a lot of changes in the SQL :(

Any comments, experience?

Anyway, it might be a good time to talk about ports to
other databases now. It would be nice if we had volunteers for
1. Postgres
2. DB2
3. Maybe MaxDB
Any volunteers for other RDBMSs?

Oliver



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]