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

[ries van Twisk]

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