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

[Xavier Perseguers]

Hi,

@anybody using DBAL: please test this patch against your install even if 
it's not Oracle. This patch does nothing "magick" but the test actually 
should simply make sure this does not break anything on non Oracle install.

Thanks

Xavier

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