this patch add the oracle database backend supporting for drupal-5.1. it have been tested with core modules. drupal-6.x-dev version will be workout soon. some core modules need to be hack for oracle SQL friendly.

this oracle driver still have some limitations. please read the INSTALL.oracle.txt for more informatons

i have upload the work to my sandbox, and you may checkout it out for a complete version:
http://cvs.drupal.org/viewcvs/drupal/contributions/sandbox/hswong3i/drup...

CommentFileSizeAuthor
#2 drupal-6.x-dev-with-oracle-1.1.patch248.14 KBmike2854
#1 drupal-6.x-dev-with-oracle.patch105.08 KBmike2854
drupal-5.1-with_oracle_db-1.0.patch101.18 KBhswong3i

Comments

mike2854’s picture

mike2854 commented
Version: 5.1 » 6.x-dev
StatusFileSize
new drupal-6.x-dev-with-oracle.patch105.08 KB

Here is patch for 6.x-dev
SQL script is imported with no error.
The installation is same as drupal-4.7

queries in 4 core modules are made Oracle friendly:
1. aggregator.module
2. block.module
3. node.module
4. user.module

Found functionalities need to be replaced.
Need further test

mike2854’s picture

mike2854 commented
StatusFileSize
new drupal-6.x-dev-with-oracle-1.1.patch248.14 KB

Added a SQL script for no table prefix in installation,
debug in drupal-6 functional compatibility,
Added pre-inserted record in stallation.
TODO:
1. need a better SQL handling in _db_query()
2. have a detail test in query result fetching.

Modified files:
1. aggregator.module
2. block.module
3. node.module
4. user.module
5. dblog.module

hswong3i’s picture

hswong3i commented
Title: add oracle database backend for drupal-5.1 (6.x-dev) » add oracle database backend to drupal-6.x-dev

here is a complete version of drupal core + oracle patch for drupal-6.x-dev. it patch the drupal-6.x-dev tarball on 2007-05-17. the supporting of DDL (http://drupal.org/node/136171, http://drupal.org/node/144765) is not a consideration within this patch, but we are able to add this supporting if DDL is ready to merge into drupal core database system for drupal-6.x-dev. by using this package the installation can handle as like as normal installation:

  1. create DB user and assign corresponding role and access right
  2. install drupal core by using installer, as like as mysql/pgsql handling. DB prefix and manually DB creation for trigger handling is no longer required.
complete oracle patched drupal-6.x-dev package
http://edin.no-ip.com/html/files/drupal-6.x-dev-0517-souvent22-2007-05-2...
oracle patched drupal-6.x-dev
http://edin.no-ip.com/html/files/drupal-6.x-dev-0517-with-oracle-2.0.patch
original drupal-6.x-dev tarball on 2007-05-17
http://edin.no-ip.com/html/files/drupal-6.x-dev-2007-05-17.tar.gz
hswong3i’s picture

hswong3i commented
Status: Active » Closed (duplicate)

this thread is duplicated with http://drupal.org/node/39260, and so will close up.

goldengalaxy’s picture

goldengalaxy commented

Below links throw Page not found error. Where else i can find the whole drupal oracle package?

complete oracle patched drupal-6.x-dev package
http://edin.no-ip.com/html/files/drupal-6.x-dev-0517-souvent22-2007-05-2...
oracle patched drupal-6.x-dev
http://edin.no-ip.com/html/files/drupal-6.x-dev-0517-with-oracle-2.0.patch
original drupal-6.x-dev tarball on 2007-05-17
http://edin.no-ip.com/html/files/drupal-6.x-dev-2007-05-17.tar.gz