[TYPO3-core] RFC #11076: DBAL: Cannot connect to non-local Oracle database with SID

[Xavier Perseguers]

Hi,

This is a SVN patch request.

Type: Bugfix

Branches: trunk

BT reference:
http://bugs.typo3.org/view.php?id=11076

Problem:
According to DBAL documentation, when connecting to Oracle, $typo_db may 
contain either a ServiceName or a SID.

But trying to connect using a SID does not work.

According to ADOdb documentation, connection is supported as this:

Server + service name:
$conn->Connect($serveraddress,'scott','tiger',$service_name);

Server + SID:
$conn->connectSID = true;
$conn->Connect($serveraddress,'scott','tiger',$SID);

Problem is that DBAL does not provide any method to set the 
driver-specific option "connectSID".

Solution:
Supplied patch allows any driver-specific option to be specified in 
localconf.php. This setting for instance can easily be set with this 
configuration:

$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array(
     '_DEFAULT' => array(
         'type' => 'adodb',
         'config' => array(
             'driver' => 'oci8',
             'driverOptions' => array(
                 'connectSID' => true,
             ),
         ),
     ),
);

Note:
This patch was co-written by Karsten during T3DD09.

-- 
Xavier Perseguers
DBAL-Member

http://xavier.perseguers.ch/en/tutorials/typo3.html
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 11076_v2.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20090518/aa8c3240/attachment-0001.txt