Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --- Step Menginstall Modul
- 1. Install composer (apabila belum terinstall) dengan command :
- ~$ apt-get install composer
- 2. Setelah composer terinstall lalu selanjutnya install modul oci dengan command :
- ~$ composer require professionalweb/oci8Pdo "dev-master"
- 3. Tambahkan class "professionalweb\oci8Pdo\Connection" sebagai pdo package, contoh :
- 'class' => 'professionalweb\oci8Pdo\Connection'
- 4. Pada konfigurasi database tambahkan parameter untuk melakukan cache schema :
- 'enableQueryCache' => false,
- 'enableSchemaCache' => true,
- 'schemaCache' => 'cache',
- 'schemaCacheDuration' => 0,
- 'queryCacheDuration' => 3600,
- 5. Contoh full konfigurasi :
- <?php
- $dsn = "TNS";
- return [
- 'class' => 'professionalweb\oci8Pdo\Connection',
- 'dsn' => 'oci:dbname=' . $dsn . ';',
- 'username' => 'username',
- 'password' => 'password',
- 'enableQueryCache' => false,
- 'enableSchemaCache' => true,
- 'schemaCache' => 'cache',
- 'schemaCacheDuration' => 0,
- 'queryCacheDuration' => 3600,
- 'on afterOpen' => function ($event) {
- $event->sender->createCommand("ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI:SS'")->execute();
- }
- ];
Add Comment
Please, Sign In to add comment