cakephp-plugin oracle_datasource

asaladino/oracle_datasource

CakePHP Oracle Datasource

Connect to an Oracle database using the OCI* PHP extension., _(*1)

Requirements

The master branch has the following requirements:, _(*2)

• CakePHP 2.2.0 or greater.
• PHP 5.4.0 or greater.

Installation

[Using Composer], _(*3)

Add the plugin to your project's composer.json:, _(*4)

{
  "require": {
    "asaladino/oracle_datasource": "0.8.*"
  }
}

Because this plugin has the type cakephp-plugin set in it's own composer.json, composer knows to install it inside your /Plugin directory, rather than in the usual vendors file. It is recommended that you add /Plugin/OracleDatasource to your .gitignore file. (Why? read this.), _(*5)

[Manual], _(*6)

• Download the OracleDatasource archive.
• Unzip that download.
• Rename the resulting folder to OracleDatasource
• Then copy this folder into app/Plugin/

[Enable], _(*7)

Add CakePlugin::loadAll(); to bootstrap.php then implement in database.php and a model., _(*8)

[database.php], _(*9)

class DATABASE_CONFIG {
    public $oracle = array(
        'datasource' => 'OracleDatasource.Oci',
        'persistent' => false,
        'host' => '127.0.0.1',
        'port' => '1521',
        'login' => 'user',
        'password' => 'oracle',
        'schema' => 'USER_SCHEMA',
        'sid' => 'orcl', // or service name
        'prefix' => ''
    );
}

[Your Model], _(*10)

App::uses('AppModel', 'Model');

class DemoState extends AppModel {
    public $primaryKey = 'st';
    public $displayField = 'state_name';
    public $useDbConfig = 'oracle';
}