While Drupal provides support for multiple databases, it's required that such databases uses the same dbms for this feature to work properly.

If my drupal it's installed on mysql and I need to access an existing Oracle database by using database.oracle.inc, after db_set_active("oracle") I get the following error message:

Fatal error: Cannot redeclare db_connect() (previously declared in /var/www/drupal/includes/database.mysql.inc:23) in /var/www/drupal/includes/database.oracle.inc on line 15

Please, could the core team developers consider to redesign database system to solve this drupal 5.x.x?

Kindest Regards,
Manuel J.

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented
Version: 4.7.3 » x.y.z

new features go into devel version.

coreb’s picture

coreb commented
Version: x.y.z » 6.x-dev

(Moving x.y.z version to a real version number) Feature Request => 6.x-dev

Paul Natsuo Kishimoto’s picture

Paul Natsuo Kishimoto commented

This is essentially asking for a database abstraction layer. There's a lot of noise about this in the database compatibility forum.

I like the idea, but even as a non-dev I realize it would be a major change.

rkerr’s picture

rkerr commented

I recently implemented this on 4.6 and the current database layer is not very different. The changes are not all that disruptive, in my opinion.

I can make patches against HEAD, and would like to get this feature in to core for the next release.

killes@www.drop.org’s picture

killes@www.drop.org commented

Provide a patch and people can look at it.

adrian’s picture

adrian commented
Status: Active » Closed (duplicate)

this issue is a duplicate of http://drupal.org/node/19522

I have been maintaining a patch that does this since drupal 4.5, and i've just added the drupal 5 version of the patch on there.