Skip to content

oracle.md

Latest commit

 

History

History
83 lines (64 loc) · 2.26 KB

oracle.md

File metadata and controls

83 lines (64 loc) · 2.26 KB

Connecting Oracle

To configure Yii DB Oracle with DI container, you need to create config/common/di/db-oracle.php configuration file.

use Yiisoft\Db\Connection\ConnectionInterface;
use Yiisoft\Db\Oracle\Connection;
use Yiisoft\Db\Oracle\Driver;

/** @var array $params */

return [
    ConnectionInterface::class => [
        'class' => Connection::class,
        '__construct()' => [
            'driver' => new Driver(
                $params['yiisoft/db-oracle']['dsn'],
                $params['yiisoft/db-oracle']['username'],
                $params['yiisoft/db-oracle']['password'],
            ),
        ],
    ],
];

Create a file config/common/params.php for common parameters.

use Yiisoft\Db\Oracle\Dsn;

return [
    'yiisoft/db-oracle' => [
        'dsn' => new Dsn('oci', 'localhost', 'XE', '1521', ['charset' => 'AL32UTF8']),
        'username' => 'user',
        'password' => 'password',
    ],
];

To use more than one database connection you can use class-aliases.

To configure without DI container, you need to follow these steps:

use Yiisoft\Cache\ArrayCache;
use Yiisoft\Db\Cache\SchemaCache;
use Yiisoft\Db\Oracle\Connection;
use Yiisoft\Db\Oracle\Driver;
use Yiisoft\Db\Oracle\Dsn;

// Dsn.
$dsn = new Dsn('oci', 'localhost', 'XE', '1521', ['charset' => 'AL32UTF8']);

// PSR-16 cache implementation.
$arrayCache = new ArrayCache();

// Schema cache.
$schemaCache = new SchemaCache($arrayCache);

// PDO driver.
$pdoDriver = new Driver($dsn, 'user', 'password'); 

// Connection.
$db = new Connection($pdoDriver, $schemaCache);

Date and Time Formats

After opening a connection, the Oracle driver will set the date and time formats to ISO 8601. This is required for the correct conversion of date and time values retrieved from the database.

The following SQL statement is executed:

ALTER SESSION SET
    NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SSXFF'
    NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SSXFFTZH:TZM'
    NLS_TIME_FORMAT = 'HH24:MI:SSXFF'
    NLS_TIME_TZ_FORMAT = 'HH24:MI:SSXFFTZH:TZM'
    NLS_DATE_FORMAT = 'YYYY-MM-DD'