This datasource provides Oracle database connectivity via the oci_* functions for CakePHP 2.x. It extends DboSource, but overrides any PDO functionality.
Original source presumed to be a CakePHP 1.x datasource. This was modified by odin88 in 2012 as described in Using Oracle in CakePHP 2.0. It was formerly available at the now-defunct snipt.org. Clinton Graham picked this up in 2015 for the University of Pittsburgh.
- Clone or place a copy of this repository in your
app/Plugins
directory, e.g.app/Plugins/OracleDS
. - Load the plugin in your
app/Config/bootstrap.php
, e.g.CakePlugin::load('OracleDS');
. - Set database config file
app\Config\database.php
as :
<?php
class DATABASE_CONFIG {
public $default = array(
'datasource' => 'OracleDS.Oracle',
'persistent' => false,
'login' => 'username',
'password' => 'pass',
'database' => 'hostname/databasename',
'prefix' => '',
'encoding' => 'utf8',
);
}
- Clone/Copy the Oracle.php file in this
\Model\Datasource\
directory into yourapp\Model\Datasource\
- Set database config file
app\Config\database.php
as :
<?php
class DATABASE_CONFIG {
public $default = array(
'datasource' => 'Datasource/Oracle',
'persistent' => false,
'login' => 'username',
'password' => 'pass',
'database' => 'hostname/databasename',
'prefix' => '',
'encoding' => 'utf8',
);
}