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

[belbono]

hey Ries,

it seems that dbal tries to connect to the other db server (List module 
hangs up while loading), but I can't test that correctly, because that 
db-server is inside an intranet.
in fact i´m developing my extension on a windows machine, but once it´s 
done, it will run on a linux server - but I think (hope) this should not 
be a problem.

anyway I tried it on a (linux-)machine from inside of the intranet and 
there typo simply ignored my settings to dbal and used the MySQL database.

so I´m going to give rvt_adodb a try.
again as a question: do I have to expect some problems because of the 
different operating systems ?

while installing rvt_adodb I got a dependency problem that said my php 
version is higher than allowed (5.2.x>=5.1.9)....this should not be a 
problem I think..?

Alex

ries van Twisk wrote:
> 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
>
>
>
>
>
>
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>
>