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

[belbono]

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