reuvers, Here is how I did it and it was for Oracle and this type of functionality is ,imho, an edge case, so I had to hack up the dbo_oracle file.
I have an application DB and dozens of target DBs(other physical servers). I have a table in the application DB that holds connection info to all the other target DBs. I dynamically load database settings using ConnectionManager and set the current one by overriding the __construct method within each model that resides on a different DB. Some caveats, you won't be able to join tables across the DBs. The way that errors are returned in cake, it only handles the last error for a single connection. Since I have to connect to dozens of DBs, I had to modify the error handling to basically return an array of connection handles => errors. But if you know in advance all of the DBs you need to connect to, you can define them in your database.php file and just override within the model file, which connection to use. humbao reuvers wrote: > How would one go about gathering information from an other oracle > database? My application contains all the relevant information > required except for a few tables i need to read from from another > oracle database > The user i'm using has read rights on that database. > > I know it's possible to do this through adding a db configuration and > using this in the model with > var $useDbConfig = 'alternate'; > > But i want to do this with something like > var $useTable = 'otherDB.tabel'; > > but is says Missing Database Table. > > does anyone know if this is possible > > thx in advance! > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
