[TYPO3-mvc] bind a foreign database to a repository

[Stefan Frömken]

Hello MVC-List,

we have a TYPO3-Database and another datebase containing only ONE table 
with some extra data. For now we tried following things in Extbase:

1.)
We made a copy of Typo3DbBackend and replaced __construct()-content with 
a local t3lib_db-object with settings for the other database. OK...it 
works, but with sqlDebug=1 we get very many error messages like 
db_name.cf_extbase_caching* not found or doesn't exists.

2.)
We mapped our Domainmodel to db_name.table within TS. Hey...this works 
good on our developer server. But on LIVE the foreign database has 
another connection settings.

3.)
DBAL works good in our old pi-base-extension. But all over in the 
internet you can read "DBAL is not jet supported by extbase". Maybe it 
will work when using native mode, because our database is MySQL and on 
the same server. The checkbox for using sql_query in ExtConf of dbal is set.

4.)
We tried to override storageBackend within the __constructor of our 
repository class. It works too, but we got the same error messages like 
in 1.)

5.) Jochen Rau has a good idea: http://forge.typo3.org/issues/5374. But 
I don't know how to do it like this.

Any further ideas?

Stefan