Re: Ports of RDBMS store to other DBs

[Oliver Zeigermann]

As I said before, I will have little time to contribute code in 
December. If people want to have the Oracle port in the 2.0 I will 
hardly be able to make it. So, if there are other volunteers for Oracle 
I would be glad to offer this job to them. If not, I would propose to 
schedule it for the 2.1 release.

Oliver

Oliver Zeigermann wrote:

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]
.





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