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

[ries van Twisk]

hey Alex,

looks good what you did...

I would debug the DBAL extension and see what went wrong...

to be honest I used rvt_adodb which has less overhead,
but is not DBAL compliant... but it does allow connecting
to other databases using a AdoDB interface.

Ries
On Sep 17, 2007, at 11:15 AM, belbono wrote:

> 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
>>
>>
>
> _______________________________________________
> 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