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

[Xavier Perseguers]

Hi,

REMINDER #1


Xavier Perseguers wrote:
> 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
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away