[TYPO3-dev] Manageing several databaes in typo3 through dbal

belbono belbono at gmx.de
Mon Sep 17 18:15:24 CEST 2007


Hi Ries,

'dbal' is installed as well as the 'adodb' extension (With dbal and 
adodb I mean the extension keys)
So I think this should be all I need, for my setup

I´m not quite sure I understand what you mean with '..different from the 
extension DBAL..'
Is there still something missing in my localconf or maybe another 
extension I have to install ?

Alex

ries van Twisk wrote:
> Hey Alex,
>
> Just to confirm...
> Did you install the DBAL extension aswell??
>
> TYPO3 core devs. call extension DBAL compliant,
> which is different from the extension DBAL that actually does the job.
>
> Ries
>
>
> On Sep 17, 2007, at 9:19 AM, belbono wrote:
>
>   
>> Hi,
>>
>> I tried to manage more then one database in Typo3 with DBal.
>> That's why I need to use an oracle database in my extension.
>>
>> I read in the manual that dbal is able to configure a handler for  
>> every
>> given table. So I made the following setup for the tables my extesion
>> uses on the oracle db server:
>>
>>
>> ext_localconf.php:
>>
>> $TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (
>>         '_DEFAULT' => array (
>>             'type' => 'native',
>>             'config' => array(
>>                 'username' => '',        // Set by default  
>> (overridden)
>>                 'password' => '',        // Set by default  
>> (overridden)
>>                 'host' => '',            // Set by default  
>> (overridden)
>>                 'database' => '',        // Set by default  
>> (overridden)
>>             )
>>         ),
>>          'oracleDB' => array (
>>             'type' => 'adodb',
>>             'config' => array(
>>                 'username' => '@my_username',
>>                 'password' => '@my_password',
>>                 'host' => 'myserver.myaddress.de:myport',
>>                 'database' => 'dbis',
>>                 'driver' => 'oci8'
>>             )
>>         ),
>>     );
>>
>> $TYPO3_CONF_VARS['EXTCONF']['dbal']['table2handlerKeys'] = array (
>> 	'tx_testext_tab1' => 'oracleDB',
>> 	'tx_testext_tab1_tab2_mm' => 'oracleDB',
>> 	'tx_testext_tab2' => 'oracleDB',
>> 	'tx_testext_tab3' => 'oracleDB',
>> 	'tx_testext_tab4' => 'oracleDB',
>> 	'tx_testext_tab5' => 'oracleDB',	
>> 	'tx_testext_tab6' => 'oracleDB',
>>     );
>>
>>
>> Unfortunately this won't work. Typo3 is still using the standard MySQL
>> database.
>>
>> Can anyone tell me how I can get this working as described in the dbal
>> manual ? Or is it maybe better to use the adodb interface directly ?
>>
>> greetings,
>> Alex
>> _______________________________________________
>> TYPO3-dev mailing list
>> TYPO3-dev at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>>     
>
> --
> Ries van Twisk
> Freelance TYPO3 Developer
> email: ries at vantwisk.nl
> web:   http://www.rvantwisk.nl/
> skype: callto://r.vantwisk
> Phone: + 1 810-476-4193
>
>
>
>
>
>
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>
>   





More information about the TYPO3-dev mailing list