guidofaecke/doctrine-dbal-ibmi

Doctrine DBAL module for DB2 on the IBM i platform

0.0.7 2018-06-01 17:40 UTC

Requires

• php: ^5.6|^7.0|^7.1
• doctrine/dbal: ^2.5

Requires (Dev)

• doctrine/orm: dev-master
• phpunit/phpunit: ^5.6

MIT

• James Titcumb
• Cassiano Vailati
• Guido Faecke

README

Doctrine DBAL module for DB2 on the IBM i platform.

Based on the original work by @cassvail in doctrine/dbal#910.

Usage

First, install with Composer:

$ composer require guidofaecke/doctrine-dbal-ibmi

Configuration

In your connection configuration, use this specific DB2Driver class, for example, when configuring for a Zend Expressive application:

<?php

return [
    'doctrine' => [
        'connection' => [
            'orm_default' => [
                'driverClass' => \DoctrineDbalIbmi\Driver\DB2Driver::class,
                'params' => [
                    'host'     => '...',
                    'user'     => '...',
                    'password' => '...',
                    'dbname'   => '...',
                    'persistent' => true,
                    'driverOptions' => [
                        'i5_naming' => DB2_I5_NAMING_OFF,
                        'i5_commit' => DB2_I5_TXN_NO_COMMIT,
                        'i5_lib' => '...',
                    ],
                ],
            ],
        ],
    ],
];

Manual Configuration

You can manually configure an EntityManager like so:

<?php

$configuration = \Doctrine\ORM\Tools\Setup::createAnnotationMetadataConfiguration([
    __DIR__ . '/../path/to/your/entities/',
], true);

$connection = [
    'driverClass' => \DoctrineDbalIbmi\Driver\DB2Driver::class,
    'host' => '...', // Replace this
    'user' => '...', // Replace this
    'password' => '...', // Replace this
    'dbname' => '...', // Look up value with WRKRDBDIRE
    'persistent' => true,
    'driverOptions' => [
        'i5_lib' => '...', // Replace this
        'i5_naming' => DB2_I5_NAMING_OFF,
        'i5_commit' => DB2_I5_TXN_NO_COMMIT,
    ],
];

$entityManager = \Doctrine\ORM\EntityManager::create($connection, $configuration);

You can then use this instance of $entityManager.