I need a database with transactions, stored procedures, foreign keys and common reqursive queries (generally SQL99-compliant) which is stable to use with zope.

Does anybody have a good suggestion on a database engine (open-source databases preferred) which is usable?

I've been using DB2 from IBM for a while, but the DA's available for it are either slow or buggy (tried ZDBI/Perl, SQLRelay and the one from those japanese dudes). None of them measure up.

I also need a database who can handle load well and has good crash-recovery. Distributed database is not _that_ important, but would be fine.

I also need to connect to my database from Java (JDBC or SQLJ), Windows ODBC and Linux-based Perl. So decent drivers for these need to exist as well.

Hope someone has some good answers or pointers. The stability and the crash-recovery is the most crucial features I need, the other can be discussed.

TIA,

-- Robin